Average of bottom 10 values in a range

M

Matt Jameson

What is the formula for taking the average of only the
*bottom 10* values in a range of 20?

Thank you for your help!

-Matt
 
B

Bernard V Liengme

Hi Matt,
This must be entered as an array function (end with Shift+Ctrl+Enter)
=AVERAGE(SMALL(A1:B100,{1,2,3,4,5,6,7,8,9,10}))
Bernard
 

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

200KB versus 35MB 0
Trying to find additional ranges outside of min, max, and average 2
Finding average of top 70% of the values 1
average out of bottom 10 values 6
Averaging data across a date range 1
How can i find the max value within a time range ased on two cells 6
averaging multiple items from one list 2
Need help with average/lookup formula 2

Top