One way:

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

You might want to make sure there are enough values to average:

=IF(COUNT(A1:E1)<3,0,(SUM(A1:E1)-MIN(A1:E1)-MAX(A1:E1))/(COUNT(A1:E1)-2))

Biff

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