How to count occurrence?

G

Guest

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
 
T

T. Valko

Try one of these:

=COUNTIF(A:A,"Done")+COUNTIF(A:A,"Warn")

=SUM(COUNTIF(A:A,{"Done","Warn"}))
 

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

How to count the number of occurrence within string? 2
How to determine the occurrence? 9
How to determine the top 5 occurrences from a list of numbers? 3
How to count the occurrence? 3
How to determine the highest occurrence? 4
How to find out the 3 highest occurrence of number from a list? 5
How to count the occurrence? 3
How to count it - 13 Dec? 1

Top