Hi,

Suppose your data is in A1:A1000 and you want an average on rows 10,20,...

1. In cell B10 enter the formula =AVERAGE(A1:A10)
2. Select cells B1:B10 and then drag the fill handle down as far as
necessary.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"MJ" wrote in message
...
I have spreadsheet with 1000 lines of data, time intervals every minute.
I
want to average every ten minutes. Is there a realtively simple way to do
this?