Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE ARRAY
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE ARRAY
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "vukgar" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Array | Excel Discussion (Misc queries) | |||
Average If Array Formula | Excel Worksheet Functions | |||
Average array | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |