How to average every 10 numeric values

E

emel24

How can I create automatically an average of every 10 numeric value i
one column and display the result in the next column?

For example, I have 3000 Readings in one column and want to see th
average of every 10 readings in the next column. So the next colum
will show 300 averaged readings without any blanc fields in between.
Is this possible
 
V

Vasant Nanavati

If your data is in A1:A3000, in B1 enter:

=AVERAGE(OFFSET(B$1,10*(ROW(B1)-1),-1):OFFSET(B$1,10*(ROW(B1)-1)+10,-1))

Copy down as needed.

Lightly tested, but should work.
 
B

Biff

Hi!

Values in A1:A3000

In B1 enter:

=AVERAGE(OFFSET(A$1,(ROW(1:1)-1)*10,,10))

Copy down to B300

Biff
 
Top