It was the add that threw me :-)
Just use
=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"CheriT63" wrote in message
...
I apologize for being unclear.
If I have various days in column A and want to know how many "yes"
responses
I have in column B to preset criteria, how would I do that. It has
nothing
to do with column C.
Instead of adding numbers, I merely want to count how many cells contain
the
Yes for the day. Say, how many Yes's were there for Monday? How many for
Tuesday? Etc.
Thanks again for your time.
"Bob Phillips" wrote:
How can you add numbers from B where B = Yes.
Assuming you meant C
=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?
Thanks for any help!
|