AVERAGE ARRAY

[vukgar]

I would like to average the 1st 7 numbers in an array (E2:E63), in the next
colum I need to average the 1st 30 numbers of E2:E63). I have tried using
=AVERAGE(E2:E63),ROW(1:7), but the number returned is double than what it
should be

 

[Bernard Liengme]

Can you tell us why you cannot use =AVERAGE(E2:E8)
If F1 holds a number (say12) and F2 the formula
=AVERAGE(INDIRECT("E2:E"&F1+1))
then you will get the average of the first 12 values in the array
But this is better
=AVERAGE(E2:INDEX(E2:E63,F1))
since it does not have the volatile INDIRECT
best wishes