I can't think of an elegant way to do this.

--
Biff
Microsoft Excel MVP


"MJ" wrote in message
...
I guess I did not give enough data. The spreadsheet is 1000 lines with 15
columns. I want to average each column at each ten rows of data. So I
would
have an average number in each of the fifteen columns after each ten rows.

Thank you.