View Single Post
  #2   Report Post  
mikerickson mikerickson is offline
Junior Member
 
Location: Winters CA
Posts: 22
Default

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

Quote:
Originally Posted by victoriaawatson View Post
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