Corrections, sorry:

Put in any starting cell, say in B2:
=AVERAGE(OFFSET(INDIRECT("A"&ROW(A1)*7-6),,,6))

The formula in B2 should be:
=AVERAGE(OFFSET(INDIRECT("A"&ROW(A1)*7-6),,,7))

and lines
B2 returns: =AVERAGE(A1:A6)
B3 returns: =AVERAGE(A7:A14)
and so on ..

should read as:
B2 returns: =AVERAGE(A1:A7)
B3 returns: =AVERAGE(A8:A14)
and so on ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---