functions to count Yes & No

F

fofo

Hi There,

I have a simple excel table, in one of the fields that is called "filled"
the answer is either (yes) or (no), I simply want to count how many "yes" and
how many "no" are there in that column, which function to use for that.
-------------------------------------------------------------------------
Filled
Yes
Yes
No
No

Total Yes: -----
Total No: -----
 
T

Trevor Shuttleworth

=COUNTIF(A:A,"yes") assuming that the "filled" column is A *and* the
result (this formula) is in a column *other* than A

Regards

Trevor
 
G

Gord Dibben

To count Yes use this formula.

=COUNTIF(A:A,"Yes") where A:A is the "filled" column.


Gord Dibben MS Excel MVP
 
Top