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
========
