Calculating average discarding lowest value

[Guest]

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

 

[somethinglikeant]

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

 

[Guest]

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.

 

[Bob Phillips]

=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)