Help with Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 15 Feb 2005 05:12 GMT

Hopefully I'm posting in the correct group for my question. I'm trying
to find an average of five of the lowest numbers in a ten number group.
Stated differently, out of ten numbers I want to find the average of
the five lowest. I'm not sure how to do that in Excel. I'd appreciate
any tips. Thank you.

Reply to this Message

JE McGimpsey - 15 Feb 2005 06:20 GMT

> Hopefully I'm posting in the correct group for my question. I'm trying
> to find an average of five of the lowest numbers in a ten number group.
> Stated differently, out of ten numbers I want to find the average of
> the five lowest. I'm not sure how to do that in Excel. I'd appreciate
> any tips. Thank you.

One way:

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5}))

Reply to this Message

Tom - 25 Feb 2005 06:40 GMT

Thank you. I'll give it a try and let you know. Many thanks for your
time.

Reply to this Message

Mac Forum / Applications / Excel / February 2005

Help with Formulas