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

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