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.
 
Back
Top