Forum Discussion
formula for the average of the lowest 8
I am using the following formula: =+AVERAGE(SMALL($F$3:$F$22,ROW($1:$8))) to calculate the average of the lowest eight in column F3:F22. I know I have to press ctrl/shft/enter to make the formula wo...
Try: =AVERAGE(SMALL(INDIRECT("F3:F22"),ROW(INDIRECT("1:8"))))
Many thanks!! I've tried it several times, and it works. Now I have given me the task to see what this formula actually is doing. I haven't come across the INDIRECT in Excel yet.
Jan
