sumproducts

[bigmacneb]

Hello, using excel 2003. Attempting to return the sum of Column C based on two criteria. For example =SUMPRODUCT((condition1=match1)*(condition2=match2)*???)
I want to total the sum of column C if condition1 and condition2 both match.
What do I need to add to =SUMPRODUCT((condition1=match1)*(condition2=match2)*???) to make it work? THANKS!!

 

[MrKowz]

Try:

=SUMPRODUCT(--(Condition1=Match1),--(Condition2=Match2),C1:C100)

Make sure that all of your ranges are identical in size.

 

[Andrew Poulsom]

What range are you trying to sum, which columns do you want to use for your conditions and what are the conditions. Example:

=SUMPRODUCT(--(A1:A10="abc"),--(B1:B10>=5),C1:C10)

 

[brans1982]

Somthing like this...

=SUMPROPDUCT((A:A=match1)*(B:B=match2)*(C:C))

 

[Aladin Akyurek]

Hello, using excel 2003. Attempting to return the sum of Column C based on two criteria. For example =SUMPRODUCT((condition1=match1)*(condition2=match2)*???)
I want to total the sum of column C if condition1 and condition2 both match.
What do I need to add to =SUMPRODUCT((condition1=match1)*(condition2=match2)*???) to make it work? THANKS!!

You need to specify the ranges involved: Condition ranges and the range to sum... like in

=SUMPRODUCT(--($A$2:$A$20=E2),--($B$2:$B$20=F2),$C$2:$C$20)

where E2 houses a condition that must hold for A2:A20, F2 another condition that must hold for B2:B2, and C2:C20 houses the figures to sum.

 

[p45cal]

Excel Workbook
	A	B	C	D	E
1
2	one	10	apples
3	three	8	oranges
4	seven	6	apples		18
5	three	3	apples		18
6	six	2	oranges
7	nine	8	apples
8	three	4	apples
9	three	10	apples
10	rtwo	2	oranges
11	six	2	apples
12	three	4	pears
13	three	4	oranges
14	one	8	pears
15	three	1	apples
Sheet