averaging lines of data at every ten lines

[MJ]

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?

 

[T. Valko]

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

 

[barry houdini]

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 todo
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))

 

[Shane Devenshire]

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]

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.

 

[T. Valko]

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