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

On Nov 12, 10:40*am, slavenp
wrote:
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!