Totalling "Yes" or "No"....
 

I have a spreadsheet that contains a column with a "Y" for yes, or "N" for
no. I'd like to automatically count how many of the cells contain "Y".

How do I go about doing so?

Thanks!

Totalling "Yes" or "No"....
 

Look in Excel help for the function COUNTIF.
--
David Biddulph

"Patrick" wrote in message
...
I have a spreadsheet that contains a column with a "Y" for yes, or "N" for
no. I'd like to automatically count how many of the cells contain "Y".

How do I go about doing so?

Thanks!

Totalling "Yes" or "No"....
 

Try,

=COUNTIF(A1:A50,"Y")

Mike

"Patrick" wrote:

I have a spreadsheet that contains a column with a "Y" for yes, or "N" for
no. I'd like to automatically count how many of the cells contain "Y".

How do I go about doing so?

Thanks!