Please correct the formula

[srizki]

I am using the following two formula,
=INDEX($L$2:$L$3583,MATCH(1,($AA$1=$R$2:$R$3583)*(AB2=$M$2:$M$3583),0))
Or
=SUMIF($L$2:$L$3583,INDEX(L:L,MATCH(1,(M:M=AB3)*(R:R=$AA$1),0)))
They both are array formula.
The problem is that they only fetch the first value matched, and I want to add all the values that are matched. How do I do this?
Thanks

 

[Eric W]

Try:

=SUMIFS(L2:L3583,R2:R3583,AA1,M2:M3583,AB2)

 

[srizki]

Thank you Eric.