Cannot get INDEX,MATCH formula to SUM

[tas666]

Hi there,
What I want: to find an exact match based on 1-3 criteria and then sum all the results in a particular column

My solution: so far it's =SUM(INDEX(AlmaSource!N:AD,MATCH(1,(AlmaSource!Y:Y=H2)*(AlmaSource!AB:AB=K2),0),1,1))

Unfortunately that doesn't SUM anything, just returns the first result. Any ideas?

Oh, and I'm open to running this in any way at all, the INDEX thing is sloooooow but I only have to do it once, but I'm matching a table of 1000 rows on a table of 4000 lines so I'm okay with slow if it works.

Example attached.

PS I think it would have been quicker to do this by hand with how long I spent today on this.

[XLent]

You should be using SUMIFS

=SUMIFS(AlmaSource!N:N,AlmaSource!$Y:$Y,$G2,AlmaSource!$AB:$AB,$L2)
copied across

the INDEX/MATCH will only return data relative to first match found and, as you note, that particular construct is quite slow.

[Bo_Ry]

Please try at B2

=SUMIFS(AlmaSource!N:N,AlmaSource!$Y:$Y,$I2,AlmaSource!$AB:$AB,$L2)

[tas666]

Oh gosh that was easy. I guess I used the other way because I initially only needed to actually match results, and only realised about half way through that the darn things had multiple rows that needed adding. SUMIFS is so much easier. Thanks heaps! Off I go to write heaps of permeations of this. Thanks XLent and Bo_Ry!