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.
Bookmarks