Dear All Experts and Geniuses |
May I kindly request your help I need the two formulas in Cell G10 and Cell G11 to read from Cell G8 instead of Cell G9 |
Cell G10 =SUM(FILTER($D$6:$D$371,($B$6:$B$371>G9-IF(MOD(DAY(G9),7)=0,7,MOD(DAY(G9),7)))*($B$6:$B$371<=G9))) |
Cell G11 =SUMPRODUCT(($B$6:$B$371 > G9 - IF(MOD(DAY(G9), 7) = 0, 7, MOD(DAY(G9), 7))) * ($B$6:$B$371 <= G9) * ($D$6:$D$371)) |
Any assistance is greatly appreciated. |
Regards |
P.S. At home I use 365 Microsoft at the office some colleagues and myself use Excel 2016 |
The formula in Cell G10 was a great help from expert AliGW |