averaging lines of data at every ten lines
 

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?

averaging lines of data at every ten lines
 

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?

averaging lines of data at every ten lines
 

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

averaging lines of data at every ten lines
 

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?

Additional data
 

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.

Additional data
 

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.