Thread: 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 <k_OAe.4091$IU1.2057@fe11.lga>,
"thomas wald" <thomaswald@microsoft.com> 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
donaldb@281.com
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-AADE67.06551112072005@msnews.microsoft.com...
> 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 <k_OAe.4091$IU1.2057@fe11.lga>,
> "thomas wald" <thomaswald@microsoft.com> wrote:
>
> > I need a formula that will figure the average of any range of numbers
> > dropping the lowest number
> >
> > Thomas Goldstein