getting an average while excluding high and low input
 

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)

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)