How to Use MINIFS in Google Sheets (With Examples)


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:

MINIFS in Google Sheets with one criteria

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:

Google Sheets MINIFS with multiple criteria

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

Leave a Reply

Your email address will not be published. Required fields are marked *