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

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