Last Updated on November 1, 2023 by Jake Sheridan

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)**”

## Summary

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.

#### More basic math formulas in Google Sheets:

- Addition
- Subtract
- Multiply
- Divide
- Exponents
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Trimmean
- Sum Columns or Rows
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula