Try =COUNTIF(filled,"yes")

HTH
Regards,
Howard

"fofo" wrote in message
...
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: -----
-------------------------------------------------------------------------
Thank you in advance for your help.