Arrow left
Back to product 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

  1. Type “=MEDIAN” or go to “Insert” in the menu bar➝“Function”➝”Statistical”➝”MEDIAN”
  2. 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).
  3. Press the “Enter” key.
How to insert the MEDIAN formula from the menu bar

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:

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 this article to learn how to use the AVERAGE formula.

Analyze your live financial data in a snap

Are you learning this formula to process financial data, build a financial model, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access more than fifty templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

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

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711