Counting 'Yes' or 'No'

  • Thread starter Thread starter slavenp
  • Start date Start date
S

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!
 
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!
Click to expand...

Check out the COUNTIF function in HELP.
--ron
 
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
 
Try this ="Yes - "&COUNTIF(Range,"Yes")&" No - "&COUNTIF(Range,"No")
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
 
Back
Top