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