Automation of Averages (X-posted)

[bachya1208]

Hi everyone,

I have the following situation: I have 10,000 numbers all in the firs
column (A) in an Excel spreadsheet. I need to computer the averages o
every 10 numbers (that is, the average of A1:A10, A11:A20, A21:A30, an
so on). I know how to do this for every 1 cell (just by dragging down)
but no idea how to do it for every 10 cells. Doing this by hand mean
that I'm going to have to deal with 1,000 separate values
manually...and that's not fun.

Any ideas? Thanks.
Edit/Delete Messag

 

[Guest]

One approach is to put
=AVERAGE(A1:A10)
in B1, select cells B1:B10 (the formula and 9 blank cells) then either drag
down or copy, select the rest of the 10000 rows in column B and paste.

Jerry

 

[Guest]

Try this:

=AVERAGE(OFFSET($A$1:$A$10,ROW()*10-10,0))

HTH,
Elkar

 

[Peo Sjoblom]

One way

=AVERAGE(INDEX(A:A,ROWS($A$1:A1)*10-9):INDEX(A:A,ROWS($A$1:$A1)*10))

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[bachya1208]

Thank you both for your help