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?

Try this...

Assuming your data starts in A2.

Enter this formula in C2 and copy down as needed:

=AVERAGE(OFFSET(A$2,(ROWS(C$2:C2)-1)*10,,10))

This is what you'll end up with:

C2 = average of A2:A11
C3 = average of A12:A21
C4 = average of A22:A31
C5 = average of A32:A41
etc
etc

--
Biff
Microsoft Excel MVP


"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?

On Dec 28, 4:52*pm, MJ wrote:
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?

Assuming your data to average is in A1:A1000 then you can average
every 10 cells with this formula in C1 copied down

=AVERAGE(OFFSET(A$1,ROWS(C$1:C1)*10-10,0,10))

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?

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.

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.