Is there a way to get an average, excluding the lowest number?

I need to get an average of a set of numbers and either exclude the lowest
number in the set OR make sure that only numbers over 10,000 are in the
average -- does anyone know how to do this?

look up the database functions in excel (function wizard-database functions)

DAverage is the most out of the box solution available.

"TNTraining" wrote:

> I need to get an average of a set of numbers and either exclude the lowest
> number in the set OR make sure that only numbers over 10,000 are in the
> average -- does anyone know how to do this?

Thanks Tom... I tried to use DAverage, however I was not successful -- have
you ever used it?

"TomHinkle" wrote:

> look up the database functions in excel (function wizard-database functions)
>
> DAverage is the most out of the box solution available.
>
> "TNTraining" wrote:
>
> > I need to get an average of a set of numbers and either exclude the lowest
> > number in the set OR make sure that only numbers over 10,000 are in the
> > average -- does anyone know how to do this?

=AVERAGE(IF(A1:A5<>MIN(A1:A5),A1:A5))

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"TNTraining" <TNTraining@discussions.microsoft.com> wrote in message
news:FD442FBF-56E7-410B-88E8-FF93BF75361F@microsoft.com...
> I need to get an average of a set of numbers and either exclude the lowest
> number in the set OR make sure that only numbers over 10,000 are in the
> average -- does anyone know how to do this?

Note that if there are more than one instance of the minimum value, then
all of the minimum values will be excluded.

i.e., if all the values in the range are the same, this formula will
return #DIV/0!



In article <uAmx1B7ZFHA.3032@TK2MSFTNGP10.phx.gbl>,
"Bob Phillips" <phillips@tiscali.co.uk> wrote:

> =AVERAGE(IF(A1:A5<>MIN(A1:A5),A1:A5))
>
> which is an array formula, so commit with Ctrl-Shift-Enter

One way:

Exclude lowest:

=(SUM(rng)-MIN(rng))/(COUNT(rng)-1)

Exclude <=10000 (array-enter:CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(rng>10000,rng))



In article <FD442FBF-56E7-410B-88E8-FF93BF75361F@microsoft.com>,
"TNTraining" <TNTraining@discussions.microsoft.com> wrote:

> I need to get an average of a set of numbers and either exclude the lowest
> number in the set OR make sure that only numbers over 10,000 are in the
> average -- does anyone know how to do this?

If you really mean OR, so if answering the first half of your question is
OK:

=(SUM(YourRange)-MIN(YourRange))/(COUNT(YourRange)-1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"TNTraining" <TNTraining@discussions.microsoft.com> wrote in message
news:FD442FBF-56E7-410B-88E8-FF93BF75361F@microsoft.com...
>I need to get an average of a set of numbers and either exclude the lowest
> number in the set OR make sure that only numbers over 10,000 are in the
> average -- does anyone know how to do this?

THANK YOU to all of you for your help!!!!!!!

"TNTraining" wrote:

> I need to get an average of a set of numbers and either exclude the lowest
> number in the set OR make sure that only numbers over 10,000 are in the
> average -- does anyone know how to do this?