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
