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