Need to calculate simple formula for cells

[victoriaawatson]

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

 

[Peo Sjoblom]

=COUNTIF(Range,"Yes")


replace Range with the cell references needed

 

[mikerickson]

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

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?

Thank