Table of Contents
Excel is an incredibly powerful tool that allows users to quickly calculate and analyze data. In this article, we will discuss how to use the Excel MIN IF formula to find the minimum value in a range of cells that meet multiple criteria. We will discuss the components of the formula, how to use the formula, and a few examples of how it can be used. By the end of this article, you will be able to use the MIN IF formula to quickly and accurately find the minimum value from a range of cells that meet multiple criteria.
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.
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 .