Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF based on several criteria. | Excel Worksheet Functions | |||
Can I use sumif with OR to sum based on two column criteria? | Excel Worksheet Functions | |||
sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
SumIf based on two criteria | Excel Worksheet Functions | |||
Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions |