How to Calculate the Median in Excel

Techwalla may earn compensation through affiliate links in this story.
Excel can calculate the median for you automatically.
Image Credit: Ingram Publishing/Ingram Publishing/Getty Images

The median is the middle number in a range of numbers. If you have data in an Excel 2013 workbook, you can use a simple formula to calculate the median. This may be easier and more accurate than trying to work it out manually, especially if you are dealing with a large set of numbers.


Step 1

Open a new worksheet in Excel. Click on the first cell in the first column and type the number "1" (without the quotation marks) into the cell.

Video of the Day

Step 2

Click on the cell below or press "Enter" on your keyboard to go to it automatically. Type "2" (without the quotation marks) in this cell. Repeat the process until you have numbers 1 through 5 in cells A1 through A5 in the column.


Step 3

Click on an empty cell where you want the median calculation to appear. This cell can be directly under your list of numbers or anywhere else on the sheet.


Step 4

Type "=MEDIAN(A1:A5)" (without the quotation marks) into the cell. This tells Excel to calculate the median across your range of cell numbers. Press the "Enter" key and you should see the median number appear in the cell designated in Step Three.



Report an Issue

screenshot of the current page

Screenshot loading...