Help with Formulas

T

Tom

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.
 
J

JE McGimpsey

Tom said:
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.
Click to expand...

One way:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Trying to find additional ranges outside of min, max, and average 2
Dropping the lowest value 1
Need help with a formula 3
Need a formula for a descimal integer into a whole number 1
Excel 2007 average formula 4
Need Help with Macro Security 1
Assign points based on two conditions 1

Top