"yes" addition

D

DaveAsh

Hi,
Probably a quick answer to this, but how do you add up the number of yes's
in a column?

Regards,
Dave
 
S

Sandy Mann

=COUNTIF(A1:A100,"Yes")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top