Sumproduct with Condition OR Sumproduct with ADDRESS function - HE

  • Thread starter Thread starter gholly
  • Start date Start date
G

gholly

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!
 
1. It depends. Would need a more detailed explanation of what you want to
do.

2. =SUMPRODUCT(--(A2:A8="T1"),B2:B8,C2:C8)
 
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
 
Back
Top