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
---------------
Jacob Skaria


"Jim" wrote:

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