Hello Fellow ExcelForum-ers!
I am encountering an issue that I feel has a very easy fix.
Below are the equations in 3 cells. They are averaging intervals of 7 cells without overlap.
=AVERAGE(A2:A8)
=AVERAGE(A9:A15)
=AVERAGE(A16:A22)
If I autofill, Excel does not seem to be able to recognize that pattern. Instead, Excel adds 1 to each row so that the fourth cell is as follows:
=AVERAGE(A17:A23)
But rather, the fourth cell should be the following:
=AVERAGE(A23:A29)
Is there a way to autofill with the 7 cell intervals?
Thanks in advance for taking the time to read this!
Best,
Gray-ish
Bookmarks