Average formula

  • Thread starter Thread starter thomas wald
  • Start date Start date
T

thomas wald

I need a formula that will figure the average of any range of numbers
dropping the lowest number

Thomas Goldstein
 
One way:

=(SUM(rng)-MIN(rng))/(COUNT(rng)-1)

This assumes that you mean to drop only one value if there are multiple
instances of the "lowest number".
 
Or an array formula to exclude all instances of the minimum value
=AVERAGE(IF(H1:H14<>MIN(H1:H14),H1:H14))
to be entered with ctrl+shift+enter
 

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
Average Function but exclude info 4
Excel Sumproduct 0
Formula for 6 lowest #'s in a range then average of them. 2
help with formula please 1
Excel Rainfall Formula 2
Need help for Excel Formula 0
Help with Date Range Formula 6

Back
Top