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

=COUNTIF(A1:A100,"Yes")

Adjust the range to suit.

Dave
--
Brevity is the soul of wit.


"Meenie" wrote:

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

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

Thanks Dave F... that's wonderful!
Now the next step is how do I make it tell me the % of yes.
ie: 10 questions. 10 yeses are 100%, 9 yesses are 90%, 8 yesses are 80%
?? (You can see I'm terrific at formulas... I really am pretty new at Excel
and thought I was doing so great... finally got the formulas down for adding,
subtracting, etc. but this has boggled my brain totally.
Is there somewhere in "help" that you find these things like "countif" etc?,
I sure couldnt find it <sigh
Thank you for your wonderful help!

"Dave F" wrote:

=COUNTIF(A1:A100,"Yes")

Adjust the range to suit.

Dave
--
Brevity is the soul of wit.


"Meenie" wrote:

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

Thank you, John, I'll be sure to do that!

"John Bundy" wrote:

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