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!