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 for the 50 states. If a cell does not equal one of the 50 abbreviations, it will be counted.

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

Thanks.