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

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" <(E-Mail Removed)> wrote in message
news:60722B1C-20E7-45F4-B202-(E-Mail Removed)...
> 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

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

Regards,
Nigel
(E-Mail Removed)



"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:60722B1C-20E7-45F4-B202-(E-Mail Removed)...
>> 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
>