Need to calculate simple formula for cells
 

I have a spreadsheet that uses columns A - Z, in some of the cells up
to here, I have the word 'yes'.

I need to know how to calculate the number of 'yeses' in the cells to
come up with how many I have.

How do I do it?

Thanks

Need to calculate simple formula for cells
 

=COUNTIF(Range,"Yes")


replace Range with the cell references needed


--
Regards,

Peo Sjoblom


"victoriaawatson" wrote in message
oups.com...
I have a spreadsheet that uses columns A - Z, in some of the cells up
to here, I have the word 'yes'.

I need to know how to calculate the number of 'yeses' in the cells to
come up with how many I have.

How do I do it?

Thanks

=COUNTIF(A:Z,"yes")
this is case insensitive.