How To Find Median In Google Sheets

In this tutorial, you will learn how to find median in Google Sheets.

The median of a data set is the middle number if all numbers are ranked in order, or the mean of the two middle numbers if there are an even number of numbers. For example, in the data set 1, 5, 8, 16, 23, 23, 24, the median is 16 because there are 3 numbers less than 16 and 3 numbers greater than 16.

To calculate the median, follow these steps:

Step 1

Select the cell you want to calculate the median in and type the following formula: “=MEDIAN(A:A)”, where the data set you want to find the median of is stored in column A

Step 2

The median of that data set will calculate in the cell, and update whenever data in the original range is updated

Step 3

If you want to calculate the median of multiple data sets, you can include multiple ranges as inputs for the MEDIAN() function. Separate each range with a comma. For example: “=MEDIAN(A:A, B:B)


Quick Navigation

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to find median in Google Sheets. Want more? Check out all the Google Sheets Tutorials.