If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sumif based on criteria on another cell
I am trying to add values in one column, if another column meets a certain
criteria. This is the formula I have come up with and it doesnt work. Please help SUMIF(B:B,"=AC10 and =AD10",C:C ) I thought I posted this question already, but could not find my post on the forum, so submitting again |
#2
|
|||
|
|||
Sumif based on criteria on another cell
Jane,
SUMIF only works with a single criteria, try eumproduct =SUMPRODUCT((B1:B100=AD10)*(B1:B100=AC10)*(C1:C1 00)) Mike "Jane" wrote: I am trying to add values in one column, if another column meets a certain criteria. This is the formula I have come up with and it doesnt work. Please help SUMIF(B:B,"=AC10 and =AD10",C:C ) I thought I posted this question already, but could not find my post on the forum, so submitting again |
#3
|
|||
|
|||
Sumif based on criteria on another cell
It worked ... Thank you Mike!!!
"Mike H" wrote: Jane, SUMIF only works with a single criteria, try eumproduct =SUMPRODUCT((B1:B100=AD10)*(B1:B100=AC10)*(C1:C1 00)) Mike "Jane" wrote: I am trying to add values in one column, if another column meets a certain criteria. This is the formula I have come up with and it doesnt work. Please help SUMIF(B:B,"=AC10 and =AD10",C:C ) I thought I posted this question already, but could not find my post on the forum, so submitting again |
#4
|
|||
|
|||
Sumif based on criteria on another cell
SUMIF(B:B,"=AC10 and =AD10",C:C )
Assuming: AC10 is your upper boundary value AD10 is your lower boundary value =SUMIF(B:B,"="&AD10,C:C)-SUMIF(B:B,""&AC10,C:C) -- Biff Microsoft Excel MVP "Jane" wrote in message ... I am trying to add values in one column, if another column meets a certain criteria. This is the formula I have come up with and it doesnt work. Please help SUMIF(B:B,"=AC10 and =AD10",C:C ) I thought I posted this question already, but could not find my post on the forum, so submitting again |
Thread Tools | |
Display Modes | |
|
|