How to use Median IF function in google sheets ( Easy Guide )

In this tutorial, we will learn How to use the median if function in google sheets

To use the Median IF function in Google Sheet you can use the below formula:

Syntax

MEDIAN(value1, [value2, ...])
  • When you have a list of numbers within a group, you can use the above formula to calculate a Median .

How to use Median IF function in google sheets : Step by Step Guide

In this example, we will go through the steps in detail on How to use Median IF Function in Google Sheets

We will try to calculate the median of the following dataset consisting of football teams with Player’s names and Points table.

How to use the median if function in google sheets

We will calculate the median of the points scored by each player from a different team.

Step 1 : Make a list of Unique teams using the  =UNIQUE() function

Using the =UNIQUE() function we will create a list of unique teams.

We will write the below formula into cell E2:( Adjust the formula as per your requirement )

=UNIQUE(A2:A14)

Press Enter

Step 2 : Calculate Median points using =MEDIAN() function

Now we will calculate the Median points scored by various players from different teams.

Syntax

MEDIAN(value1, [value2, ...])
  • Using the above syntax we will write the below formula into cell E2 .
=MEDIAN(C2:C14)

Press enter,Now we have the median points in the Median Points Table

Step 3 : Now copy the formula in rest of the cells

To copy the formula simply drag the corner of the first cell using the mouse cursor in the Median points column till the end

Now you will have the formula applied in all the remaining cells with a calculated Median .

We hope this tutorial on How to use the median if function in google sheets was helpful

Additional Resources :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )