Table of Contents
MINIFS is a powerful function in Google Sheets that allows you to perform calculations on multiple ranges of data. It can be used to calculate the min, max, average, and other aggregate values from a set of data. It can also be used to compare two or more ranges of data and to find the minimum value between them. MINIFS is a great tool for summarizing data and creating graphs in Google Sheets.
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:
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.
The following tutorials explain how to perform other common operations in Google Sheets: