MINIFS Function Explained
The MINIFS function in Microsoft Excel is used to find the minimum value in a range of cells that meet multiple criteria. It takes up to 127 range/criteria pairs as arguments, and returns the minimum value from the range that meets all of the criteria.
MINIFS Function Syntax
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- min_range: The range of cells to be evaluated for the minimum value.
- criteria_range1: The range of cells to be evaluated against criteria1.
- criteria1: The criteria in the form of a number, expression, cell reference, or text that defines which cells in criteria_range1 will be used to find the minimum value.
- criteria_range2: (optional) The range of cells to be evaluated against criteria2.
- criteria2: (optional) The criteria in the form of a number, expression, cell reference, or text that defines which cells in criteria_range2 will be used to find the minimum value.