Automation of Averages (X-posted)
 

Hi everyone,

I have the following situation: I have 10,000 numbers all in the first
column (A) in an Excel spreadsheet. I need to computer the averages of
every 10 numbers (that is, the average of A1:A10, A11:A20, A21:A30, and
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 means
that I'm going to have to deal with 1,000 separate values,
manually...and that's not fun.

Any ideas? Thanks.
Edit/Delete Message


--
bachya1208
------------------------------------------------------------------------
bachya1208's Profile: http://www.excelforum.com/member.php...o&userid=34026
View this thread: http://www.excelforum.com/showthread...hreadid=537863

Automation of Averages (X-posted)
 

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

"bachya1208" wrote:


Hi everyone,

I have the following situation: I have 10,000 numbers all in the first
column (A) in an Excel spreadsheet. I need to computer the averages of
every 10 numbers (that is, the average of A1:A10, A11:A20, A21:A30, and
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 means
that I'm going to have to deal with 1,000 separate values,
manually...and that's not fun.

Any ideas? Thanks.
Edit/Delete Message


--
bachya1208
------------------------------------------------------------------------
bachya1208's Profile: http://www.excelforum.com/member.php...o&userid=34026
View this thread: http://www.excelforum.com/showthread...hreadid=537863

Automation of Averages (X-posted)
 

Try this:

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

HTH,
Elkar


"bachya1208" wrote:


Hi everyone,

I have the following situation: I have 10,000 numbers all in the first
column (A) in an Excel spreadsheet. I need to computer the averages of
every 10 numbers (that is, the average of A1:A10, A11:A20, A21:A30, and
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 means
that I'm going to have to deal with 1,000 separate values,
manually...and that's not fun.

Any ideas? Thanks.
Edit/Delete Message


--
bachya1208
------------------------------------------------------------------------
bachya1208's Profile: http://www.excelforum.com/member.php...o&userid=34026
View this thread: http://www.excelforum.com/showthread...hreadid=537863

Automation of Averages (X-posted)
 

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" wrote
in message ...

Hi everyone,

I have the following situation: I have 10,000 numbers all in the first
column (A) in an Excel spreadsheet. I need to computer the averages of
every 10 numbers (that is, the average of A1:A10, A11:A20, A21:A30, and
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 means
that I'm going to have to deal with 1,000 separate values,
manually...and that's not fun.

Any ideas? Thanks.
Edit/Delete Message


--
bachya1208
------------------------------------------------------------------------
bachya1208's Profile:
http://www.excelforum.com/member.php...o&userid=34026
View this thread: http://www.excelforum.com/showthread...hreadid=537863

Automation of Averages (X-posted)
 

Thank you both for your help.


--
bachya1208
------------------------------------------------------------------------
bachya1208's Profile: http://www.excelforum.com/member.php...o&userid=34026
View this thread: http://www.excelforum.com/showthread...hreadid=537863