Hi,

I have the following array formula that returns a single numerical value from tables based on 3 lookup criteria. It works perfectly.

=INDEX(OFFSET($A$1,MATCH($J3,$A$1:$A$19,0),2,5,4),MATCH($J3&$K3,$A$1:$A$19&$B$1:$B$19,0)-MATCH($J3,$A$1:$A$19,0),MATCH($L3,OFFSET($A$1,MATCH($J3,$A$1:$A$19,0)-1,2,1,4),0))

But, I now have multiple tables in the same sheet, and want the array formula to return a sum of all values available with the 3 lookup criteria.
Not just the single value from the first instance of the 3 lookup criteria, as it does presently.

Is there an easy way to do so?

[I tried simply adding SUM( ) to the front of the formula, but it didn't work]

Thank you in advance.