Hello everyone,
Any help would be greatly appreciated....
I think I need a SUMPRODUCT with INDEX MATCH x2 to match 3 variabkle inputs against 2 ranges to sum when all criteria is met. Essentially my criteria is:
Match F22 in I20:K20
Match F20 in I21:K30
Match F22&F24 in L20:Q20
Return sum of L21:Q30
It is difficult to explain in words so I have attached a decent sample dataa set with expected result.
Thank you in advance
Bookmarks