MEDIAN Function

Summary

MEDIAN returns the middle number in a set of values. Excel sorts the numbers behind the scenes and then picks the center point, so you do not need to arrange the data yourself first.

This is often a better way to describe what is typical when the list contains one unusually high or unusually low value. A few extremes can pull the average away from what most people actually experience, but the median usually stays closer to the middle of the real pattern.

MEDIAN is useful when the middle value tells a clearer story than the arithmetic average. It is especially helpful in datasets with outliers, where a few very large or very small values can distort the mean and make the typical case harder to see.

Syntax

=MEDIAN(number1, [number2], ...)

You can use cell references, ranges, typed numbers, or a mix of them. Excel supports up to 255 arguments.

Arguments

• number1 - [required] The first number, cell reference, or range to include.
• number2, ... - [optional] More numbers, references, or ranges to include.

MEDIAN vs Other Functions

These functions all summarize the center of a dataset, but they answer slightly different questions.

Using the MEDIAN Function

A simple way to think about MEDIAN is this: it answers the question, "What is the value in the middle once everything is lined up?" That makes it especially useful for prices, salaries, wait times, and other real-world numbers where a few unusual entries can distort the average.

Microsoft notes a few rules that are easy to miss. If you type values directly in the argument list, logical values and text representations of numbers are counted. But when MEDIAN looks at ranges or references, text, logical values, and blank cells are ignored, while zero is still counted. That difference matters when you are comparing a formula built from typed values with one built from a worksheet range.

If the dataset has an odd number of values, MEDIAN returns the single middle number. If the dataset has an even number of values, there is no single middle entry, so Excel returns the average of the two middle values. That is why the result can sometimes be a number that does not appear in the original list.

Example 1 - Find the middle value in a range

This is the standard use case for MEDIAN. Excel takes the numbers, sorts them behind the scenes, and then finds the value sitting in the middle position.

That makes the result different from an average. You are not getting the arithmetic mean, you are getting the center point of the ordered list.

=MEDIAN(B1:B5) // Returns the middle value from the range.

Example 2 - Use MEDIAN when one value is far too large

In this list, 1000 is much larger than the other values. If you used an average, that one outlier would pull the result upward and make the group seem more typical than it really is.

The median avoids that problem by focusing on the middle position instead of the size of every value. That is why it stays at a more realistic center for this kind of list.

=MEDIAN(A1:A5) // Returns 30.

Example 3 - Show a typical value from a wider range

When you use a wider range, the median becomes a summary of a larger group instead of just a few values. This is helpful when you want one number that feels more typical than the average in data with uneven highs and lows.

That is why median is common in salary, price, and response-time reports. It often reflects the middle experience better than the mean.

=MEDIAN(B1:B10) // Returns the middle value from the full range.

Example 4 - Use the middle score as a fairer benchmark

This works well in score and performance sheets because one or two unusually high or low results can distort the average. The median gives you the middle result instead, which often feels fairer as a baseline.

That makes it useful when you want to describe what is typical rather than what the arithmetic mean happens to be.

=MEDIAN(B1:B10) // Returns the middle score in the range.

Conclusion Recap

MEDIAN is useful when you want the middle value instead of the usual average. This lesson showed why that matters, especially when one number is much bigger or smaller than the rest.

Excel sorts the values for you and returns the center point, so you do not need to arrange the data yourself. That is why MEDIAN is often a better choice for prices, salaries, wait times, and scores when extreme values would make the average feel misleading.

• Main job: MEDIAN returns the middle value in a set of numbers.
• No manual sorting needed: Excel handles the ordering for you.
• Even-number rule: If there are two middle values, Excel averages them.
• Outlier-friendly: MEDIAN is often better than AVERAGE when extremes distort the mean.
• Range behavior: In references, text, logical values, and blanks are ignored, but zero is counted.
• Typical use: Great for prices, salaries, response times, and scores.