functions to count Yes & No
 

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.

functions to count Yes & No
 

Assuming range is A1:A100

=COUNTIF(A1:A100,"yes")
=COUNTIF(A1:A100,"no")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551637

functions to count Yes & No
 

=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


"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.

functions to count Yes & No
 

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.

functions to count Yes & No
 

To count Yes use this formula.

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


Gord Dibben MS Excel MVP

On Tue, 13 Jun 2006 12:49:02 -0700, fofo wrote:

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.