Im trying to take the average of groups of 10 cells that are part of a data set that is ordered in 1 column but has some 15000 entries. Do I have to change "manually" the cells range in the formula

AVERAGE(A1:A10)

to

AVERAGE(A11:A20)

I tried with Data Analysis but it only changes

AVERAGE(A1:A10)

in to

AVERAGE(A2:A11)

How complicated would be to use a For Next loop in VBA code to indicate the range and "set" of data to calculate?

Thanks in advance

Sebastian