=COUNTIF(A:Z,"yes")
this is case insensitive.
Quote:
Originally Posted by 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
|