You can use the following basic in Excel to find the minimum value in a range only if multiple criteria are met:

=MINIFS(C2:C11, A2:A11, "Mavs", B2:B11, "<5")

This particular formula finds the minimum value in the cell range **C2:C11** only if the value in the range **A2:A11** is equal to “Mavs” and the value in the range **B2:B11** is less than 5.

The following example shows how to use this formula in practice.

**Example: Formula for MIN IF Multiple Criteria in Excel**

Suppose we have the following dataset in Excel that contains information about various basketball players:

Suppose we would like to find the minimum value in the points column only *if* the corresponding value in the team column is “Mavs” and the corresponding value in the assists column is less than 5.

We can use the following formula to do so:

=MINIFS(C2:C11, A2:A11, "Mavs", B2:B11, "<5")

We’ll type this formula into cell **E2** and then press Enter:

The formula returns a value of **22**.

This is the minimum points value among rows where the team is equal to “Mavs” and the assists is less than 5.

We can confirm this by manually checking which rows meet both of these requirements:

The two rows highlighted in green are the only two rows where the team is equal to “Mavs” *and* the assists value is less than 5.

Between these two rows, the one with the lowest points value is **22**, which matches the value returned by our formula.

Note that in this example we used the **MINIFS** function with two criteria, but you can use as many criteria as you’d like.

You can find the complete documentation for the **MINIFS** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Find Max Value by Group

Excel: How to Calculate the Average by Group

Excel: How to Use MIN Function and Exclude Zero