Excel - MEDIAN Function, Calculating Median, Example and Usage

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

MEDIAN Function and Examples

USING THE MEDIAN FUNCTION IN EXCEL - ILLUSTRATIVE EXAMPLES

The median is the number that lies in the middle of a set of numbers or the number where half the numbers in the set are greater than it and half are less than it. To calculate this median, you can use the MEDIAN function in Excel with the syntax below.

The MEDIAN function in Excel indicates the median of a given set of numbers. Although calculating the median using this function may seem simple, not everyone fully understands its significance and usage. Follow the article below to learn more.

MEDIAN Function and Examples

USING THE MEDIAN FUNCTION IN EXCEL - ILLUSTRATIVE EXAMPLES

Syntax: MEDIAN (Number1, [number2],…)

Where:
- Number1 is mandatory.
- Number2,… are optional

Number1, number2,… form a series of numbers to calculate the median, ranging from 1 to 255 numbers. Arguments must be in numerical format, any text, logical values, empty cells will be ignored except cells containing the value zero (0).

Illustrative Example: Given a table of students' scores, calculate the median score of those students.

Using the formula in cell C11: MEDIAN(D5,D6,D7,D8,D9) or MEDIAN(D5:D9)

The result is:

It's quite simple to use the MEDIAN function to calculate the median of a series of numbers, isn't it? This article has helped you understand the significance and usage of this function more clearly. Additionally, you can explore using other functions to perform calculations on Excel spreadsheets more efficiently.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]