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.

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. Excel orders the values and returns the one in the middle.

=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 bigger than the rest. The median still lands on the middle of the group instead of being pulled upward.

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

Example 3 - Show a typical value from a wider range

When you want a center point from a larger block of data, MEDIAN can give a more realistic summary than a straight average.

=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 the middle result often feels more realistic than the mean when a few values are unusually high or low.

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

Conclusion Recap

• 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.