One way


=AVERAGE(INDEX(A:A,MATCH(9.99999999999999E+307,A:A )-3):INDEX(A:A,MATCH(9.99999999999999E+307,A:A)))



Regards,

Peo Sjoblom


"keving" wrote:

I am sure there is a simple way!
each week I insert a number in a column, thus after 6 weeks I have A1:A6
filled in. Each week I need to take the average of the last 4 numbers. How
can I calculate this automatically without having to change the range each
time?
from Kevin