COUNTIF for "not equal to" with multiple criteria

**crayhons** · 06-11-2013, 10:20 AM

Hi all,

I'm looking for some help on creating a "not equal" to COUNTIF or SUMPRODUCT that will go through a specific column (G) and will check all the cells for each abbreviation of the 50 states. If a cell does not equal one of the 50 abbreviations, it will be counted. This will be used in VBA.

If I need to explain more, please let me know. Any help would be great.

Thanks.

**daddylonglegs** · 06-11-2013, 10:33 AM

Try listing the 50 abbreviations on the worksheet, e.g. in Z1:Z50 then use this formula to count cells in G2:G1000 that are not blank and not equal to any of the abbreviations

=SUMPRODUCT(ISNA(MATCH(G2:G1000,Z1:Z50,0))*(G2:G1000<>""))

COUNTIF for "not equal to" with multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display

COUNTIF for "not equal to" with multiple criteria

Re: COUNTIF for "not equal to" with multiple criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions