I am trying to calculate the value from a table based on multiple rows and columns. the attached file has the data in the 'Closed' tab. The criteria is as follows:
1) Closed column A = SEAU OS A1
2) Closed column B = In Home
3) Closed column C = TAT
4) Closed column D = Total
5) Closed row 1 = SEAU OS B1
as an example, taking INFINET for A1 and week 30 (AE1), the returned value should be 13.5
I have tried various iterations of SUMIFS, SUMPRODUCT and no luck.