How to Calculate the Median in Excel

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.

Rows and Columns of Numbers
Excel can calculate the median for you automatically.
credit: Ingram Publishing/Ingram Publishing/Getty Images

Step

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.

Step

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

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

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.