using Average, Maximum & Minimum

[Cozmo2]

I need to find the average of a range of numbers after elimating the highest and lowest numbers. Any ideas?
Thanks

 

[bluedragon2]

(SUM(range)-MAX(range)-MIN(range))/COUNT(range)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

opps:

(SUM(range)-MAX(range)-MIN(range))/(COUNT(range)-2)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[fneily]

=SUM(Testrange)-LARGE(Testrange,1)-SMALL(Testrange,1)/(COUNT(Testrange)-2)

Testrange is the name of the range of your numbers.

 

[mintjulep]

=(SUM(A1:A5)-MAX(A1:A5)-MIN(A1:A5))/(COUNT(A1:A5)-2)

 

[Cozmo2]

Thank-you, you make it look so easy!