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!