Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting entries which match specified criterial
I have the below table and I would like to count how many "ANC" entries are
ongoing. The first column range is called "anclist" with the second called "status2". Using the array formular below excel 2003 returns a count of too {=SUM((anclist="anc141")*(status2="ongoing"))} However when i use a wildcard as noted in the formular below, to expand the search the formular fails. {=SUM((anclist="anc*")*(status2="ongoing"))} Item status ANC141 ongoing ANC142 closed CNC001 closed ANC144 ongoing ANC141 ongoing CNC010 Closed ANC147 ongoing Any idea's suggetions would be appreciated... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting entries | Excel Discussion (Misc queries) | |||
counting entries | Excel Worksheet Functions | |||
Counting entries | Excel Worksheet Functions | |||
Counting number of row entries | Excel Discussion (Misc queries) | |||
Counting Entries | Excel Worksheet Functions |