Vikash เขียน:
Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I can't do it manually and if I use the average function it averages the
first 10 and then 2-11 while it should average 10-20 and so on.

Please help, Thank you.

If A2:A6000 contain your data.

B2

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(ROWS($A$2:A 2)-1),0,10,1)))

Copy down.

If B1 is represent number of next 10 cells (1 -- 1-10, 2 --
11-20...) that can manual change the number what you want and show
result in B2 only.

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(B1-1),0,10,1)))