getting an average while excluding high and low input

  • Thread starter Thread starter cm
  • Start date Start date
C

cm

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)
 
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
 
Back
Top