In B1 enter
=AVERAGE(INDIRECT("A"&1+10*(ROW()-1)&":A"&2500+10*(ROW()-1)))
and copy down the column.
This will average the average ranges
A1:A2500
A11:A2510
A21:A2520
A31:A2530
A41:A2540
A51:A2550

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Danny" wrote in message
...
I have an excel spreadsheet that has 50,000 rows and all info ins in one
column. I would like to consolidate it to 10,000. When I go to B1 and put
in
=average(A1:A2500) it averages fine. However when copying this code and
pasting it in B2 the formula turns into =average(A2:A2501). I would like
to
have these numbers increment by 10 instead of 1. Is this possible? Please
let
me know!