Total of Yes's in a column

  • Thread starter Thread starter Shaun
  • Start date Start date
S

Shaun

Hi,

How can I formulate a query that returns the total number of yes's in a
column?

Thanks for your help
 
=COUNTIF(A1:A3000,"yes")
Not case sensitive. That's usually good when it comes to counting results.
 
You must log in or register to reply here.

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

sumproduct to calculate total based on non-continuous columns? 1
Excel Subtracting multiple columns from another column 3
Access Dcount (multiple criteria) 3
Find/Replace - from old to new 1
Looking formula that SUM values with specific value in neighboring colum 2
Looking formula that gives total of remaining months 6
Find 2 values & return row number 1
Average Question 2

Back
Top