Countif - problem counting text, other text

G

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF STOPS COUNTING 12
COUNTIF 2
Counting text problem - formula works initially 3
CountIF or COUNTA for specific text 6
counting every other cell containing text 4
COUNTIF Function 5
Using COUNTIF to count explicit text that DOES NOT include other text 8
Text Data Series 1

Top