Average of low five numbers?

[dcnatlou]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Nigel]

Probably why the OP was asking how to calculate the average!
--

Regards,
Nigel
(e-mail address removed)