< Go Back

Excel MEDIAN Function

What is the Excel MEDIAN Function?

The MEDIAN Function on Excel is used to return the middle number (Median) in the group of numbers supplied to it. The MEDIAN function can also be used to find the Median of a row of numbers in a spreadsheet.

Formula 1

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

Explanation

  • Number 1 – any number out of the range of numbers whose median is to be gotten.
  • Number 2 – any other number out of the numbers whose median is to be gotten.

The data (numbers) can be fed to the MEDIAN function as numbers, ranges, or cell references that contain numeric values and Up to 255 numbers can be fed into the function.

Formula 2

To use the MEDIAN function to find the Median of a row of numbers in a spreadsheet, the following formula can be used;

=MEDIAN(range)

Explanation 2

  • Range – a range of cells containing values e.g. B4:G4.

Note: The function would ignore cells that contain logical values, text, or no value at all and would only return a numeric value as the median (the result).

Example

How to use the Excel MEDIAN Function

The spreadsheet used in this example has different values already distributed into Rows 1 through to 3. The Median of each row would be gotten, starting with Row 1 (B4:G4).

The following steps are to be taken;

  1. Open the existing spreadsheet containing the values, as below, or create your own new spreadsheet.

Figure 1. Open your Excel spreadsheet

  1. Click on cell I4 (the cell where the Median of Row 1 values would be displayed).

Figure 2. Cell for row1 Median

  1. Insert the formula =MEDIAN(B4:G4) to get the Median for Row 1.

Figure 3. Insert formula for row1 Median

  1. Press Enter. The median is displayed.

Figure 4. Press Enter

  1. For the median of Row 2 (B5:G5), insert the formula =MEDIAN(B5:G5) and press Enter.

Figure 5. Median for row2

  1. For the median of Row 3 (B6:G6), insert the formula =MEDIAN(B6:G6) and press Enter.

Figure 6. Median for row3

“A”, “Bobby”, and “C” in row 3 would be ignored as they are not numeric values.

  1. You can try to get the MEDIAN of the entire array of values. Use =MEDIAN(B4:G6) as the formula.

Figure 7. Overall median

Notes

  • The MEDIAN function would ignore cells that contain logical values, letters, text/strings, or no value at all and would only return a numeric value as the median (the result).
  • In our example, strings like “Bobby” & “Chick” and were ignored by the MEDIAN function. Likewise letters like “A” & “C”.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar