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: ?
Use the CountIf
function.
Syntax: =CountIf(range, "Yes")
Use COUNTIF
function.
The COUNTIF
function counts the number of cells within a range that meet a single criterion that you specify.
as per your reference the syntax should be...
Syntax: =COUNTIF(<RANGE>,"Yes")
Eg.: =COUNTIF(B2:B25,"Yes")