functions to count Yes & No

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,

I have a simple excel table, in one of the fields that is called "filled"
the answer is either (yes) or (no), I simply want to count how many "yes" and
how many "no" are there in that column, which function to use for that.
-------------------------------------------------------------------------
Filled
Yes
Yes
No
No

Total Yes: -----
Total No: -----
 
=COUNTIF(A:A,"yes") assuming that the "filled" column is A *and* the
result (this formula) is in a column *other* than A

Regards

Trevor
 
To count Yes use this formula.

=COUNTIF(A:A,"Yes") where A:A is the "filled" column.


Gord Dibben MS Excel MVP
 

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

How do I count # of cells with same value other column? 4
Access Dcount (multiple criteria) 3
Formula to answer YES or No 4
how to count#cells w/= value in other column and not count blank c 4
Custom pivot formula 2
Excel Count from last specific text 3
Count Multiple Text Entries 1
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top