Mathematics Trick for Excel

Basically what you’re doing is taking the sum of the range, subtracting the lowest number from that, and then dividing by the number of numbers minus the one you subtracted. So try this:

=(SUM(X:Y)-MIN(X:Y))/(COUNT(X:Y)-1)