Count Text Values

[Andy Roberts]

I have a column which contains text values whichare either yes /no. How can
I get a totals column at the bottom whichcounts the number of "Yes" values.
I'm fine if the cell contents are actual numbers but how do I do it if they
are text?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007

 

[ozgrid.com]

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

 

[Andy Roberts]

Thanks Dave - just the job.

--
Regards

Andy

Andy Roberts
Win XP, Office 2007