=average - eliminate the top and bottom number

[Jim]

Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

 

[Fred Smith]

=(sum(a:a)-min(a:a)-max(a:a)/(count(a:a)-2)

Regards,
Fred.

 

[Jacob Skaria]

Assuming you have the numbersin ColA ..

=(SUM(A:A)-MIN(A:A)-MAX(A:A)/(COUNT(A:A)-2))

If this post helps click Yes

 

[Rick Rothstein]

I think you have a closing parenthesis out of place.

 

[T. Valko]

Another one:

=TRIMMEAN(A1:A10,2/COUNT(A1:A10))

 

[Jacob Skaria]

Thanks Rick...

=(SUM(A:A)-MIN(A:A)-MAX(A:A))/(COUNT(A:A)-2)

If this post helps click Yes