Enter this anywhere, and copy down as needed:

=AVERAGE(INDEX(A:A,5*ROWS($1:1)-4):INDEX(A:A,5*ROWS($1:1)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"excel0003" wrote
in message ...

davesexcel Wrote:
is this in one cell??

=AVERAGE(A1:A5)&" "&AVERAGE(A6:A10)&" "&AVERAGE(A11:A15)


I have 1 column but 1000 rows.
i want to get,
1st cell =average a1 to a5
2nd cell=average of a6 to a10

continue to
last cell= average A(1000-5) to a1000.


will appreciate


--
excel0003
------------------------------------------------------------------------
excel0003's Profile:
http://www.excelforum.com/member.php...o&userid=37914
View this thread: http://www.excelforum.com/showthread...hreadid=574434