And one more interpretation <bg:
=(SUM(A1:A10)-MIN(A1:A10))/(COUNT(A1:A10)-1)



Bob Phillips wrote:

I am reading this not as the average subtract the lowest value, but as the
average of all but the lowest value. If so, you can use

=AVERAGE(IF(A1:A5<MIN(A1:A5),A1:A5))

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
= AVERAGE(A1:A10)-MIN(A1:A10)

Mangesh



"ingersollg" wrote in message
...
I need the average of an array of values, minus the lowest value of
those
entries.



--

Dave Peterson