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.

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 andIF 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.