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