excuse me Elkar, i just want to learn here,
from formula
=(SUM(A1:A10)-MIN(A1:A10)-MAX(A1:A10))/(COUNT(A1:A10)-2)
I type on A1:A10 (10 cells non-blank)
1,1,3,3,3,3,3,3,6,6
the result is 3.125
please clarify...

"Elkar" wrote:

Try this:

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

HTH,
Elkar


"frosterrj" wrote:

What would be the best way to use the avg() function (or any other
appropriate function) on a column or row while excluding the highest and
lowest value?

is this possible in one cell, or does it have to be split up using min() and
max() somewhere to exclude the value?

Thanks,
Robert