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 :)