How to Calculate the Median in Microsoft Excel – How-To Geek

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.
By submitting your email, you agree to the Terms of Use and Privacy Policy.
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Read more…
Microsoft Excel logo on a green background
Calculating the median is useful in many cases. With its MEDIAN function, Microsoft Excel makes it easy to find the median for any odd or even set of numbers. Here’s how.
The median is the number in the middle of a sorted set of numbers. For example, if your numbers are 1, 2, 3, 4, and 5, your median is 3. Or, if your numbers are 1, 8, and 9, the median is 8.
However, in the case that the count of numbers in your series is even, the average of the two middle numbers is considered the median. Notably, the median is different from the mean, which is the average of a set of numbers.
Keep in mind that Excel ignores any empty cells while calculating the median.
RELATED: How to Quickly and Easily Delete Blank Rows and Columns in Excel
To start the median calculation process, first, open your spreadsheet with Microsoft Excel. In your spreadsheet, select the cell in which you want to display the resulting median.
Select a cell in an Excel spreadsheet.
In the selected cell, type the following formula using the MEDIAN function and press Enter. In the function, replace D2 and D6 with the range where you have your numbers.
Type the MEDIAN function in the selected cell.
If you’d like to directly enter your numbers in the function, then enter your numbers in the function as shown below. Each number is separated by a comma.
Enter the MEDIAN function with direct values.
You will see the resulting median in your selected cell.
The result of the MEDIAN function.
And that’s it.
As you’re working with numbers, you might also find it helpful to find the percentage of change in Excel.
RELATED: How to Find the Percentage of Difference Between Values in Excel
RSS Feed
The Best Free Tech Newsletter Anywhere
By submitting your email, you agree to the Terms of Use and Privacy Policy.


Leave a Comment