Table of Contents
MAXIFS is a Google Sheets function that allows you to find the maximum value within a range of cells, based on a set of criteria. It is similar to the MAX function but with the additional capability of applying criteria to narrow down the specific cells you want to consider when finding the max value. MAXIFS can be used in combination with other functions and operators to create more complex formulas for data analysis. Examples are provided in the article.
You can use the MAXIFS function in Google Sheets to find the max value in a range, filtered by a set of criteria.
This function uses the following basic syntax:
=MAXIFS(range, criteria_range1, criteria1, [criteria_range2, criteria2, …])
The following examples show how to use this syntax in practice.
Related:
Example 1: Use MAXIFS with One Criterion
Suppose we have the following dataset that shows the points scored by 15 different basketball players:
We can use the following formula to calculate the max points scored IF the player is on team A:
=MAXIFS(C2:C16, A2:A16, "A")
The following screenshot shows how to use this formula in practice:
We can see that the max points value among players on team A is 35.
Example 2: Use MAXIFS with Multiple Criteria
Suppose we have the same dataset that shows the points scored by 15 different basketball players:
We can use the following formula to calculate the max points scored IF the player is on team A and IF the player has a Guard position:
=MAXIFS(C2:C16, A2:A16, "A", B2:B16, "Guard")
The following screenshot shows how to use this formula in practice:
We can see that the max points value among players who are on team A and have a Guard position is 30.
Note: In these examples we used the MAXIFS() function with one criterion and two criterion, but you can use the same syntax to use as many criterion as you’d like.
The following tutorials explain how to perform other common operations in Google Sheets: