Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file with a few columns. The columns have yes/no answers. I would like to know the function to count all yes and no answers.

Thanks for helping an excel rookie.

share|improve this question

Use COUNTIF.

So if you have a column C with values 1 through 5 as follows:

1 - Yes
2 - No
3 - Yes
4 - No
5 - Yes

Formula would read:

=COUNTIF(C1:C5,"Yes")

This would output a result of 3.

share|improve this answer
    
=COUNTIF(C1:C5;"Yes") the comma doesn't work for me. use the ; instead. – user511558 Oct 20 '15 at 0:04
    
Should be marked as the answer – user001 Jan 25 at 10:06

You must log in to answer this question.

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