Excel how to SUM a column filled with Yes’s and No’s

microsoft excelworksheet-function

I'm not summing numbers, but rather the number of occurrences of a keyword.

How is that done?

Sample Data:

Item  Completed
a     No
b     No
c     Yes
d     Yes
e     No

Total Completed: ?

Best Answer

This should do the job:

Related Question