Average of low five numbers?
You said you want the low 5 numbers, but the example you gave is for the low
6 numbers (0,1,2,3,4,5) and the average you gave is wrong for either one
(the average for the low 5 numbers 0,1,2,3,4 is 2 and the average for the 6
numbers you gave is 2.5). Here is the formula for the average of the low 5
numbers...
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5}))
and this one for the low 6 numbers....
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
NOTE: These are array entered formulas and must be committed by pressing
Ctrl+Shift+Enter, not just Enter by itself.
Rick
"dcnatlou" wrote in message
...
Example:
1 2 3 4 5 6 7 8 9 10
3 5 6 7 8 2 1 4 9 0
I want to take low five numbers and average them.
So, 0,1,2,3,4,5 avg. 3
|