#### Calculating average discarding lowest value

```How can I calculate an average automatically dropping the lowest value--I am
requested to use SUM, MIN and Count functions.
Thanks
``` 0 7/29/2006 9:55:02 PM excel  39879 articles. 2 followers. 3 Replies 404 Views Similar Articles

[PageSpeed] 31

```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

``` 0 7/29/2006 10:22:29 PM
```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
>
>
``` 0 7/29/2006 10:39:02 PM
```=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" <abmorgan@gmail.com> wrote in message
> 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
>

``` 0 7/29/2006 11:17:56 PM Similar Artilces: