Counting 'Yes' or 'No'

[slavenp]

has I have a list of information that answers either yes or no. I would like
to be able to count how many yes and no answer there are in the coloum.

If you need extra info, let me know.

I am using excel 2007.

Thanks for the help!

 

[Ron Rosenfeld]

has I have a list of information that answers either yes or no. I would like
to be able to count how many yes and no answer there are in the coloum.

If you need extra info, let me know.

I am using excel 2007.

Thanks for the help!

Check out the COUNTIF function in HELP.
--ron

 

[Mike H]

Hi,,

=COUNTIF(A1:A1000,"yes")

And of course change to NO for no.

Mike

 

[Pete_UK]

It would be helpful to know what column those values of yes and no are
in - assume it is column F. You can use these formulae to count them:

=COUNTIF(F:F,"Yes")
=COUNTIF(F:F,"No")

Don't put the formulae in column F.

Hope this helps.

Pete

 

[Warren Easton]

Try this ="Yes - "&COUNTIF(Range,"Yes")&" No - "&COUNTIF(Range,"No")
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.

 

[slavenp]

Thanks for the help guys!

Check out the COUNTIF function in HELP.
--ron