Calculating average discarding lowest value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

inspiredtoo - 29 Jul 2006 22:55 GMT

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

Reply to this Message

somethinglikeant - 29 Jul 2006 23:22 GMT

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

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

Reply to this Message

inspiredtoo - 29 Jul 2006 23:39 GMT

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.

> I think it would be =(SUM(range)-MIN(range)) / (count(range)-1))
>
[quoted text clipped - 5 lines]
> > requested to use SUM, MIN and Count functions.
> > Thanks

Reply to this Message

Bob Phillips - 30 Jul 2006 00:17 GMT

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

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

Signature

HTH

Bob Phillips

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

> I think it would be =(SUM(range)-MIN(range)) / (count(range)-1))
>
[quoted text clipped - 5 lines]
> > requested to use SUM, MIN and Count functions.
> > Thanks

Reply to this Message

Rate this thread: