ExcelBanter - Sumproduct with Condition OR Sumproduct with ADDRESS function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumproduct with Condition OR Sumproduct with ADDRESS function - HE (https://www.excelbanter.com/excel-discussion-misc-queries/243929-sumproduct-condition-sumproduct-address-function-he.html)

gholly

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!

T. Valko

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!

Eduardo

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!

All times are GMT +1. The time now is 04:37 AM.