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

Regards,
Fred.

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