# How to Perform a Median IF Function in Google Sheets

You can use the following formula to perform a Median IF function in Google Sheets:

```=MEDIAN(IF(GROUP_RANGE=VALUE, MEDIAN_RANGE))
```

This formula finds the median value of all cells in some range that belong to a certain group.

When you type this formula into a cell, you need to press Ctrl + Shift + Enter since this is an array formula.

The following example shows how to use this function in practice.

### Example: Median IF Function in Google Sheets

Suppose we have the following dataset that shows the total points scored by 15 different basketball players:

Now suppose we’d like to find the median of the points scored by players on each team.

To do so, we can use the =UNIQUE() function to first create a list of the unique teams. We’ll type the following formula into cell F2:

`=UNIQUE(B2:B16)`

Once we press enter, a list of unique team names will be displayed:

Next, we can use the =MEDIAN() function to find the median number of points scored by players on each team.

We’ll type the following formula into cell G2 and press Ctrl + Shift + Enter so Google Sheets knows this is an array formula:

`=MEDIAN(IF(B2:B16=F2, C2:C16))`

We’ll then copy and paste this formula into the remaining cells in column G:

That’s it!

Column F displays each of the unique teams and column G displays the median of the points scored by players on each team.

The following tutorials explain how to calculate other common metrics in Google Sheets:

## 2 Replies to “How to Perform a Median IF Function in Google Sheets”

1. Kyle S says:

Hey Zach, quick supplemental question to your post:
Do you know how we can apply a wildcard to the “value” statement?

To build on your example, if our list of teams also had the year (e.g., 1976 Lakers, 1981 Spurs) could we apply a pre-fix wildcard?

My expectation is the formula would be:

=MEDIAN(IF(B2:B16=”*”&F2, C2:C16))

But that did not work. Looking forward to your input, thanks!

2. Michael says:

Seems to require the ARRAYFORMULA function just like the STDEV+IF