Automation of Averages (X-posted)

  • Thread starter Thread starter bachya1208
  • Start date Start date
B

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
 
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
 
Back
Top