Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE
Hi All! Been trying to figure this out for hours, but can't do it. Hope you
can help solve this mystery for me! First 2 questions: 1. Does SUMPRODUCT work with ADDRESS functions embedded within? If no, then: 2. How can you combine SUMPRODUCT with a single condition? So with this, here's the scenario: Order # Qty 1 Qty 2 T1 1 2 T1 1 1 T1 3 1 T2 2 1 T2 1 1 T3 2 2 T3 1 2 So I want the SUMPRODUCT(Qty1,Qty2) for Order T1. The correct answer here would be 6. Hope you can help solve this! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE
1. It depends. Would need a more detailed explanation of what you want to
do. 2. =SUMPRODUCT(--(A2:A8="T1"),B2:B8,C2:C8) -- Biff Microsoft Excel MVP "gholly" wrote in message ... Hi All! Been trying to figure this out for hours, but can't do it. Hope you can help solve this mystery for me! First 2 questions: 1. Does SUMPRODUCT work with ADDRESS functions embedded within? If no, then: 2. How can you combine SUMPRODUCT with a single condition? So with this, here's the scenario: Order # Qty 1 Qty 2 T1 1 2 T1 1 1 T1 3 1 T2 2 1 T2 1 1 T3 2 2 T3 1 2 So I want the SUMPRODUCT(Qty1,Qty2) for Order T1. The correct answer here would be 6. Hope you can help solve this! Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE
Hi,
how do you get 6 as per your example should be 9, if 9 is correct use =SUMPRODUCT(--(A4:A6="T1"),(B4:B6)+(C4:C6)) change range to fit your needs "gholly" wrote: Hi All! Been trying to figure this out for hours, but can't do it. Hope you can help solve this mystery for me! First 2 questions: 1. Does SUMPRODUCT work with ADDRESS functions embedded within? If no, then: 2. How can you combine SUMPRODUCT with a single condition? So with this, here's the scenario: Order # Qty 1 Qty 2 T1 1 2 T1 1 1 T1 3 1 T2 2 1 T2 1 1 T3 2 2 T3 1 2 So I want the SUMPRODUCT(Qty1,Qty2) for Order T1. The correct answer here would be 6. Hope you can help solve this! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT with If condition | Excel Worksheet Functions | |||
Sumproduct 'Or' Condition | Excel Worksheet Functions | |||
SUMPRODUCT with an IF condition? | Excel Discussion (Misc queries) | |||
Sumproduct: condition with ? | Excel Discussion (Misc queries) | |||
Sumproduct with condition??? | Excel Discussion (Misc queries) |