How do I drop the lowest 2 numbers and then average?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
one way:
=(SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2})))/(COUNTA(A1:A100)-2)
 
=AVERAGE(SMALL(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2))))
Array entered (ctrl+shift+enter)
 
Sorry you needed to exclude the smallest 2 entries
Change "small" to "large" so correct formula will be
=AVERAGE(LARGE(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2))))
Array entered (ctrl+shift+enter)
 
You must log in or register to reply here.

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 find additional ranges outside of min, max, and average 2
Extract the 2 Lowest % 3
nested "IF" function in Excel 2007 2
Finding the average by dropping the lowest 1
#DIV/0! error using Avgerage 15
remove lowest 2 values in a row? 2
Return the 2 lowest numbers within a range 6
optimization 1

Back
Top