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 <[email protected]>,
"thomas wald" <[email protected]> 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
[email protected]
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> "thomas wald" <[email protected]> wrote:
>
> > I need a formula that will figure the average of any range of numbers
> > dropping the lowest number
> >
> > Thomas Goldstein