Example
=COUNTIF(A1:A5,"yes")

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Meenie" wrote in message
...
Here's my problem :) I'm making a spreadsheet with a series of questions.
The
answers are all Yes or No (or N/A). How do I get it to add up the number
of
Y'es" answers? I used conditional formatting to color each cell (green for
yes, red for no white for n/a (which is ignored). But how to I total the
number of "yes" or green cells?
That's all I want it to do, tell me the number of yesses across each row.
But I've no idea how to tell it to do that <sigh
I can add up numbers just fine, but this has me befuddled!
Thanks for any help you can offer :)