Average of low five numbers?
 

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

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

Average of low five numbers?
 

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

Regards,
Nigel




"Rick Rothstein (MVP - VB)" wrote in
message ...
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