MEDIAN
Returns the middle value — the one an outlier can't drag around.
Syntax
MEDIAN(number1, [number2], ...)
Statistical Functions.
A worked example
=MEDIAN(C2:C9)
Returns $1,888
The middle value once the orders are sorted.
Where it goes wrong
With an even count it averages the two middle values, so the result may not be a figure that appears in your data.
Consider instead: AVERAGE, when the distribution is even and every value should pull its weight.