| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting text problem - formula works initially | Excel Worksheet Functions | |||
| counting a text value based on another text value. | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Countif and Text - not counting | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
Linear Mode
