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
Additional Resources :
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets