MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting yes/no in excell


Posted by Carol on December 10, 2001 1:59 AM

I am creating an excell spreadsheet which will require the program to count answers that are "yes" and answers that are "no." Is there a function to facilitate this need? If so, please advise.



Posted by Aladin Akyurek on December 10, 2001 2:43 AM

Carol --

Just use COUNTIF as in


=COUNTIF(A1:A50,"Yes")

which will count all entries in A1:A50 that are equal to Yes.

The same structure holds of course for counting the "No" values.

Aladin

========