I have determined that it doesn't matter which cell in the array is dropped.
I used portions of two of the responses and came up with:
=(SUM(B4:T4)/(COUNT(B4:T4)-1))
and it works exactly as I needed it to. Thanks to all who responded.
Jerry Ingersoll
"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.
|