Forum Discussion
Rolling 12-Month Average
I want to have a column showing a rolling 12-month average for each individual contributor. The table is laid out like this (showing a full 12 months with the previous months' columns hidden): Name ...
In B2:
=AVERAGE(OFFSET(B2, 0, 1, 1, 12))
or
=AVERAGE(INDEX(2:2, 3):INDEX(2:2, 14))
Fill down.