Total of Yes's in a column

S

Shaun

Hi,

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

Thanks for your help
 
H

Harald Staff

=COUNTIF(A1:A3000,"yes")
Not case sensitive. That's usually good when it comes to counting results.
 

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
Incone & Expenses Statement 0
sumproduct to calculate total based on non-continuous columns? 1
Consolidation Table from Different Excel Tabs with Different Format 1
Looking formula that SUM values with specific value in neighboring colum 2
Average Question 2
Arriving at totals 2
Two Totals from the same column 2

Top