I think you have a closing parenthesis out of place.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
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