getting an average while excluding high and low input
Hi,
Because the OP never used the big white space to ask the question I too get
an error. Another way
=TRIMMEAN(A1:A5,2/COUNT(A1:A5))
But what happen if there are 2 max or min, that requires a different
approach if you want them all excluding
Mike
"cm" wrote:
got an error trying to reply to post:
for values in a1 to a5:
try this
=(SUM(A1:A5)-MAX(A1:A5)-MIN(A1:A5))/(ROWS(A1:A5)-2)
|