1

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: ?

3 Answers 3

5

This should do the job:

=COUNTIF(B2:B5,"Yes")
2

Use the CountIf function.

Syntax: =CountIf(range, "Yes")

2
  • 1
    I think you need to use" instead of '... Feb 19, 2013 at 19:52
  • @PeterAlbert you are correct
    – Kristian
    Feb 19, 2013 at 19:54
1

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")

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .