# 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.

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