functions to count Yes & No

[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: -----
-------------------------------------------------------------------------
Thank you in advance for your help.

[Bearacade]

Assuming range is A1:A100

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

[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


"fofo" <[email protected]> wrote in message
news:[email protected]...
> 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.

[L. Howard Kittle]

Try =COUNTIF(filled,"yes")

HTH
Regards,
Howard

"fofo" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Gord Dibben]

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 <[email protected]> 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.