Array Formula Problems???

[ewarwoowar]

Hi All, I need help with the below:



What I need is a formula that provides the sum of column C based on the criteria in A & B. So for ALPHA TYPE 1, I need the result to be 6.

Cheers in advance.

 

[Jonmo1]

Basic syntax for multiple criteria sum is

=SUMPRODUCT((Range1=Criteria1)*(Range2=Criteria2),RangeToSum)

Note, Each range reference must be of equal size, and cannot be entire column refs like A:A. You must specify Row #s like A1:A100

so for example,

=SUMPRODUCT((A1:A100="ALPHA")*(B1:B100="TYPE1"),C1:C100)

you can replace "ALPHA" and "TYPE1" with Cell references containing those values.

 

[Peter_SSs]

like this?

Excel Workbook
	A	B	C	D	E	F	G
1	Class	Type	Result		Class	Type	Sum
2	ALPHA	TYPE 1	2		ALPHA	TYPE 1	6
3	ALPHA	TYPE 2	3		ALPHA	TYPE 2	3
4	ALPHA	TYPE 1	4
5	BETA	TYPE 1	5
6	GAMMA	TYPE 1	6
7	DELTA	TYPE 1	7
Sums

 

[Gerald Higgins]

=SUMPRODUCT(--(A2:A7="ALPHA"),--(B2:B7="TYPE1"),C2:C7)

(with help from VoG II and Hotpepper in this post from the other day . . .)
http://www.mrexcel.com/board2/viewtopic.php?t=287460&highlight=