Average formula
 

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

In article ,
"thomas wald" wrote:

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

Thomas Goldstein

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

--
Don Guillett
SalesAid Software

"JE McGimpsey" wrote in message
...
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".

In article ,
"thomas wald" wrote:

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

Thomas Goldstein