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


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

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