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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Split form 0
Section and Page numbering 0
Count if data falls within a range AND that has a certain criteria 1
Counting Text 1
how to count#cells w/= value in other column and not count blank c 5
Duplicate entry in a column/row 14
How do I count # of cells with same value other column? 4

Top