average formula

[amiebarnes]

I need a formula to average a group of numbers taking out the lowest number. Such as

15 28 37 62 41 92 74 has an average of 49.86 using the =average formula. What I am looking for is a formula that will do this average and take out the minimum number automatically so the same group of numbers will return an average amount of 55.67. I would like to take into account that the list of numbers are formulas and therefore the minimum number could conceivable change

Thanks.

 

[Norman Harker]

Hi Amiebarnes!

One way:
=(SUM(A1:A7)-MIN(A1:A7))/(COUNT(A1:A7)-1)

 

[Dave R.]

another way;

=AVERAGE(IF(A1:A10>MIN(A1:A10),A1:A10))

entered with CTRL SHIFT ENTER.

I need a formula to average a group of numbers taking out the lowest number. Such as:

15 28 37 62 41 92 74 has an average of 49.86 using the =average

formula. What I am looking for is a formula that will do this average and
take out the minimum number automatically so the same group of numbers will
return an average amount of 55.67. I would like to take into account that
the list of numbers are formulas and therefore the minimum number could
conceivable change.

 

[Dave R.]

Yipes, actually disregard that! It will screw up in the case that there are

1 instances of the MIN value, so might remove the lowest 2+ values instead

of only one of the lowest.

I need a formula to average a group of numbers taking out the lowest number. Such as:

15 28 37 62 41 92 74 has an average of 49.86 using the =average

formula. What I am looking for is a formula that will do this average and
take out the minimum number automatically so the same group of numbers will
return an average amount of 55.67. I would like to take into account that
the list of numbers are formulas and therefore the minimum number could
conceivable change.