average formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
another way;

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

entered with CTRL SHIFT ENTER.




amiebarnes said:
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
Click to expand...
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.
 
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
Click to expand...
of only one of the lowest.


amiebarnes said:
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
Click to expand...
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.
 
Back
Top