The second formula makes sure there are at least 3 values to calculate. Try
the formulas on these numbers: 1;1.

Biff

"driller" wrote in message
...
excuse me biff, i just want to learn here without backgroud checking,
i test the ONE WAY of your 2 formulas
A1:E1 data 1,1,3,3,6
from
=(SUM(A1:E1)-MIN(A1:E1)-MAX(A1:E1))/(COUNT(A1:E1)-2)
and
=IF(COUNT(A1:E1)<3,0,(SUM(A1:E1)-MIN(A1:E1)-MAX(A1:E1))/(COUNT(A1:E1)-2))
both have same result =2.333

please clarify


"Biff" wrote:

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