Sumif

C

CheriT63

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!
 
B

Bob Phillips

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

CheriT63

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.
 
B

Bob Phillips

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

RagDyer

And since you're looking for a total for each day, how about entering
Monday thru Friday in Column C,
From C1 to C5,
And then enter Bob's formula in D1 with these revisions:

=SUMPRODUCT(--($A$1:$A$1000=C1),--($B$1:$B$1000="Yes"))

Then drag down to copy to D5, to get each individual day's total.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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