Counting yes's in a column

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
 
D

Dan E

Jimmy,

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

Dan E
 
Top