Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SumProduct help
I have the following formula: =SUMPRODUCT(--('Tab 2'!E3:E50='Tab
1'!D1),--('Tab 2'!C3:C50='Tab 1'!A6),Tab 2'!I3:I50) I need to change the first criteria to equal 'Tab 1!D1 or D2, but I don't know exactly how to change the formula. The result needs to sum the values in I3:I50 that also have values in column C that equal A6 and values in column E that equal D1 or D2. I hope I made that clear enough. |
#2
|
|||
|
|||
=SUMPRODUCT(--(('Tab 2'!E3:E50='Tab 1'!D1)+('Tab 2'!E3:E50='Tab
1'!D2)),--('Tab 2'!C3:C50='Tab 1'!A6),'Tab 2'!I3:I50) -- HTH Bob Phillips "Josh O." wrote in message ... I have the following formula: =SUMPRODUCT(--('Tab 2'!E3:E50='Tab 1'!D1),--('Tab 2'!C3:C50='Tab 1'!A6),Tab 2'!I3:I50) I need to change the first criteria to equal 'Tab 1!D1 or D2, but I don't know exactly how to change the formula. The result needs to sum the values in I3:I50 that also have values in column C that equal A6 and values in column E that equal D1 or D2. I hope I made that clear enough. |
#3
|
|||
|
|||
One way
=SUMPRODUCT(--(('Tab 2'!E3:E50='Tab 1'!D1)+('Tab 2'!E3:E50='Tab 1'!D2)0),--('Tab 2'!C3:C50='Tab 1'!A6),'Tab 2'!I3:I50) Regards, Peo Sjoblom "Josh O." wrote: I have the following formula: =SUMPRODUCT(--('Tab 2'!E3:E50='Tab 1'!D1),--('Tab 2'!C3:C50='Tab 1'!A6),Tab 2'!I3:I50) I need to change the first criteria to equal 'Tab 1!D1 or D2, but I don't know exactly how to change the formula. The result needs to sum the values in I3:I50 that also have values in column C that equal A6 and values in column E that equal D1 or D2. I hope I made that clear enough. |
#4
|
|||
|
|||
Great! Thanks Guys!!!
"Bob Phillips" wrote: =SUMPRODUCT(--(('Tab 2'!E3:E50='Tab 1'!D1)+('Tab 2'!E3:E50='Tab 1'!D2)),--('Tab 2'!C3:C50='Tab 1'!A6),'Tab 2'!I3:I50) -- HTH Bob Phillips "Josh O." wrote in message ... I have the following formula: =SUMPRODUCT(--('Tab 2'!E3:E50='Tab 1'!D1),--('Tab 2'!C3:C50='Tab 1'!A6),Tab 2'!I3:I50) I need to change the first criteria to equal 'Tab 1!D1 or D2, but I don't know exactly how to change the formula. The result needs to sum the values in I3:I50 that also have values in column C that equal A6 and values in column E that equal D1 or D2. I hope I made that clear enough. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |