Average of bottom 10 values in a range

  • Thread starter Thread starter Matt Jameson
  • Start date Start date
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
 
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
 
Matt,

Use the following array formula:
=AVERAGE(SMALL(A1:A20,ROW(INDIRECT("1:10"))))

Since this is an array formula, you must press Ctrl+Shift+Enter rather than
just Enter when you first enter the formula and whenever you edit it later.
If you do this properly, Excel will display the formula enclosed in curly
braces {}.
 
Back
Top