can a column for 2 different words and display a number based on how many are found

A

abailey

This should be a very easy thing to do, but I can’t figure it out.
Please Help. Thanks!

I am trying to scan a column for 2 different words and display a numbe
based on how many are found.

Example:
If the words “Completed” and “N/A” are found within a column as liste
below. I want to create a formula that will display the number 5
because those words are found 5 times within that column.

Completed
Completed
Completed
N/A
Complete
 
T

Trevor Shuttleworth

One way:

=COUNTIF(A:A,"Completed")+COUNTIF(A:A,"N/A") for column A

Regards

Trevor
 
A

Alan Beban

Another:

=SUM(COUNTIF(A:A,{"Completed","#N/A"}))

Alan Beban

Trevor said:
One way:

=COUNTIF(A:A,"Completed")+COUNTIF(A:A,"N/A") for column A

Regards

Trevor
Click to expand...
 
Top