In B1 and copy down,
=AVERAGE(INDEX(A:A, 4*ROWS(A$1:A1) - 3):INDEX(A:A, 4*ROWS(A$1:A1)))
In B1 and copy down,
=AVERAGE(INDEX(A:A, 4*ROWS(A$1:A1) - 3):INDEX(A:A, 4*ROWS(A$1:A1)))
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks