Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! ============================================== "Bob Phillips" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
SumIF | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
Sum or Sumif | Excel Discussion (Misc queries) | |||
Sumif or if statements-Help! | Excel Discussion (Misc queries) |