You can use the MINIFS function in Google Sheets to find the minimum value in a range, filtered by a set of criteria.
This function uses the following basic syntax:
=MINIFS(range, criteria_range1, criteria1, [criteria_range2, criteria2, …])
The following examples show how to use this syntax in practice.
Related: How to Use MAXIFS in Google Sheets
Example 1: Use MINIFS 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 minimum points scored IF the player is on team A:
=MINIFS(C2:C16, A2:A16, "A")
The following screenshot shows how to use this formula in practice:
We can see that the minimum points value among players on team A is 28.
Example 2: Use MINIFS 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 minimum points scored IF the player is on team A and IF the player has a Guard position:
=MINIFS(C2:C16, A2:A16, "A", B2:B16, "Guard")
The following screenshot shows how to use this formula in practice:
We can see that the minimum points value among players who are on team A and have a Guard position is 29.
Note: In these examples we used the MINIFS() function with one criterion and two criterion, but you can use the same syntax to use as many criterion as you’d like.
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets:
How to Use COUNTIF with Multiple Ranges in Google Sheets
How to Use SUMIF with Multiple Columns in Google Sheets
How to Sum Across Multiple Sheets in Google Sheets
