Countif - problem counting text, other text
 

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.?

Countif - problem counting text, other text
 

=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")

--
Biff
Microsoft Excel MVP


"gmoore3055" wrote in message
...
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.?