incremental averaging of data

[ndflyguy]

Hello, I have a large number of data points, around 7500, and I need to
average every 50 points. Is there a way to do this other than doing each one
induvidually. I tried typing in the average formula for the first couple and
filling in the rest but it doesn't fill in correctly. if I have data point
1-7500 and I want for example
AVERAGE(A1:A50)
AVERAGE(A51:A100)
AVERAGE(A101:a150) etc

When I try to fill from the first two cells i get:
AVERAGE(A1:A50)
AVERAGE(A51:A100)
AVERAGE(A3:A52)
AVERAGE(A53:102)
AVERAGE(A5:A54)


thank you , Dan.

 

[RagDyeR]

Try this:

=AVERAGE(INDEX(A:A,50*ROW(1:1)-49):INDEX(A:A,50*ROW(1:1)))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello, I have a large number of data points, around 7500, and I need to
average every 50 points. Is there a way to do this other than doing each one
induvidually. I tried typing in the average formula for the first couple and
filling in the rest but it doesn't fill in correctly. if I have data point
1-7500 and I want for example
AVERAGE(A1:A50)
AVERAGE(A51:A100)
AVERAGE(A101:a150) etc

When I try to fill from the first two cells i get:
AVERAGE(A1:A50)
AVERAGE(A51:A100)
AVERAGE(A3:A52)
AVERAGE(A53:102)
AVERAGE(A5:A54)


thank you , Dan.