Forum Discussion
Offset formula for rolling monthly calculations
In columns AU - AY of the attached file, I am trying to use the OFFSET function (within SUM) to calculate the last 11 months, last 10 months, last 9 months, last 8 months, and last 7 months, respecti...
egspen2 Not sure I understand the reason for the 44x44 matrix, but I believe you can do the calculations you describe as shown in rows 63:68. Perhaps you'll find it helpful.