Hi,,

=COUNTIF(A1:A1000,"yes")

And of course change to NO for no.

Mike

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