Counting yes's in a column

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

I have a column that is filled with yes and no entries, I
want to be able to count all the yes's and put a number at
the last row of the column. Is there a function i can
enter into that cell that will count all the yes's for
me? Thanks for the help
 
Jimmy,

If your data were in A1:A100
=COUNTIF(A1:A100,"yes")
would give your desired result

Dan E
 
Back
Top