Index match summarize all hits

[Samra]

Hi have the table below where in J8 have the following calculation: =INDEX($C$2:$G$7,MATCH(1,($A$2:$A$7=$J$3)*($B$2:$B$7=$J$4),0),MATCH($J$2,$C$1:$G$1,0))

As you see, it returns 68, which is the first hit. All fine here.

My problem is that I want to summarize all hits, i.e. 68 and 80 and get 148 (the yellow marked).

I have tried using sumif, sumifs, sum etc.. But I can't figure it out.

Grateful for help..

 

[lrobbo314]

How about this.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Color	Prio	A	B	A	C	D
2	Blue	1	19	64	52	30	17		Column	A
3	Orange	1	61	70	8	13	38		Color	Green
4	Red	2	8	89	46	17	24		Prio	2
5	Green	3	1	76	88	56	82
6	Yellow	2	62	70	65	42	93
7	Green	2	68	47	80	33	84
8									Calculation	148
Sheet1

Cell Formulas
Range	Formula
J8	J8	=SUMPRODUCT((C1:G1=J2)*(A2:A7=J3)*(B2:B7=J4)*C2:G7)

 

[Samra]

How about this.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Color	Prio	A	B	A	C	D
2	Blue	1	19	64	52	30	17		Column	A
3	Orange	1	61	70	8	13	38		Color	Green
4	Red	2	8	89	46	17	24		Prio	2
5	Green	3	1	76	88	56	82
6	Yellow	2	62	70	65	42	93
7	Green	2	68	47	80	33	84
8									Calculation	148
Sheet1

Cell Formulas
Range	Formula
J8	J8	=SUMPRODUCT((C1:G1=J2)*(A2:A7=J3)*(B2:B7=J4)*C2:G7)

Wow... Thank you. Crazy that it was that simple!