Countif - problem counting text, other text

[gmoore3055]

I have a database which lists addresses by city, state, zip. I have used
=COUNTIF(Database!H3:H33,"<A3>""1") to count the number of times I see five
specific states appear (ID,UT,OR,NV,WA) BUT I now need to calculate the rest
of the states as "Other States". Must I list every other state abbrev.?

 

[T. Valko]

=COUNTIF(Database!H3:H33,"<A3>""1")

Not sure what that's counting but I'll take your word that it works!

Get the count of the *entire* range and then subtract the result of the
above formula. Something like this:

=COUNTA(Database!H3:H33)-COUNTIF(Database!H3:H33,"<A3>""1")