Back to guides
Google Sheets Formulas

How to Use MEDIAN Function in Google Sheets

In this article, you will learn how to use the MEDIAN formula in Google Sheets.

This function is beneficial when you need to get the middle of a set of data. The median is the middle number in a list of figures. It is the point above and below which each half of the data is spread equally.

How to use the MEDIAN formula in Google Sheets

  • Type “=MEDIAN” or go to “Insert” in the menu bar➝“Function””Statistical””MEDIAN”

  • Select a set of data in which you want to find the median. If you want to incorporate non-adjacent areas, you can include them by punctuating them with a comma(s).

  • Press the “Enter” key.

Use the MEDIAN formula in Google Sheets
How to insert the MEDIAN formula from the menu bar

Why spend hours creating spreadsheets, when we have already done the work for you?
100+ financial spreadsheet templates, all free and ready for you now.
Free Spreadsheet Templates

The generic formula is as follows:

=MEDIAN(value1, [value2, …])

Value 1: A set of data based on which you want to figure out the median.

Let’s see some examples. Imagine you review five customers’ rates given to four types of products:

insert the MIN function from the menu bar
How to use the MEDIAN formula in Google Sheets

(i) Median by product

This is very simple. You can just select a part of the column for each product. For example, the MEDIAN formula in cell C10 (for Product A) contains a range of C4:C8, specifically 20,13,12, 5, and 4.

(ii) Median across Product A and C

This example might be a little tricky. As we mentioned above, if you want to select non-adjacent fields as a data set, you can use a comma(s). Select a part of the column for Product A (C4:C8), add a comma, and select a part of the column for Product C (E4:E8).

(iii) Median across all products

As you can see in the screenshot, you can select a table as a set of data which include twenty figures for all product.

How do you find the mean of data in Google Sheets?

You can use the AVERAGE function to find the arithmetic mean. Refer to How to Use AVERAGE Formula in Google Sheets to learn how to use the AVERAGE formula.

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below