How can I calculate an average automatically dropping the lowest value--I am
requested to use SUM, MIN and Count functions.
Thanks

I think it would be =(SUM(range)-MIN(range)) / (count(range)-1))

replace the word range with your actual range A1:A5 eg,


http://www.excel-ant.co.uk



inspiredtoo wrote:
> How can I calculate an average automatically dropping the lowest value--I am
> requested to use SUM, MIN and Count functions.
> Thanks

Thanks, that is a great help and it did work, however it only requires one
bracket after the -1, or at least that is what the "formula fixer" put on.
You have been a great help.

"somethinglikeant" wrote:

> I think it would be =(SUM(range)-MIN(range)) / (count(range)-1))
>
> replace the word range with your actual range A1:A5 eg,
>
>
> http://www.excel-ant.co.uk
>
>
>
> inspiredtoo wrote:
> > How can I calculate an average automatically dropping the lowest value--I am
> > requested to use SUM, MIN and Count functions.
> > Thanks
>
>

=AVERAGE(IF(rng<>MIN(rng),rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"somethinglikeant" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I think it would be =(SUM(range)-MIN(range)) / (count(range)-1))
>
> replace the word range with your actual range A1:A5 eg,
>
>
> http://www.excel-ant.co.uk
>
>
>
> inspiredtoo wrote:
> > How can I calculate an average automatically dropping the lowest
value--I am
> > requested to use SUM, MIN and Count functions.
> > Thanks
>