Average formula

T

thomas wald

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

Thomas Goldstein
 
J

JE McGimpsey

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".
 
D

Don Guillett

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
Using SUMPRODUCT to find weighted averages 0
200KB versus 35MB 0
Need help with a formula 3
Autonumber field in Excel that behaves the same as Access 0
Sorry if already here. Average HELP!!! 4
Ignoring Blank cells 9
Average Function but exclude info 4

Top