Average array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of data comprising a series of 25 arrays. I would like to
generate an array whose elements are the average of the corresponding
positions in each of the 25 arrays.

Suppose, for example, the first array is in cells A1 to A1000, the 2nd in
A1001 to A2000, etc. What formula would give me the average of A1, A1001,
A2001, ..., A24001?
 
Hi

In cell B1 enter
=AVERAGE(OFFSET($A$1,(ROW()-1)*1000,0,1000,1))
and copy down through cells B2:B25
 
I think this is simple

In cells C1 put the formula
=average(A1:A1000)

the copy this formula to cells C2 - C25.
C1 to c25 will be your array of averages.
 
Am I missing something or is it very simple?

=average(A1:A1000)

this will copy as
=average(A1001,2000)
=average(A2001,3000)
=average(A3001,4000)

etc
 
Well, I think not. Copying down
=AVERAGE(A1:A1000)
will create
=AVERAGE(A2:A1001)
=AVERAGE(A3:A1002)
etc.
 
Back
Top