Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count occurrence?
Under column A, there is a list of Result - "DONE", "WARN", ""
I would like to count the number of occurrence of "DONE" and "WARN" in column, and return the result in cell B1, such as Under Column A DONE DONE WARN DONE There are 4 occurrences for DONE or WARN, then 4 is return in cell B1 . Does anyone have any suggestions? Thank in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count occurrence?
Try one of these:
=COUNTIF(A:A,"Done")+COUNTIF(A:A,"Warn") =SUM(COUNTIF(A:A,{"Done","Warn"})) -- Biff Microsoft Excel MVP "Eric" wrote in message ... Under column A, there is a list of Result - "DONE", "WARN", "" I would like to count the number of occurrence of "DONE" and "WARN" in column, and return the result in cell B1, such as Under Column A DONE DONE WARN DONE There are 4 occurrences for DONE or WARN, then 4 is return in cell B1 . Does anyone have any suggestions? Thank in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count occurrence between two specific dates | Excel Discussion (Misc queries) | |||
Count occurrence of character within a cell | Excel Discussion (Misc queries) | |||
Match Last Occurrence of Numeric Value and Count BACK to Previous | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
occurrence (last) reference | Excel Discussion (Misc queries) |