MINIFS function
Summary
Returns the minimum value among cells specified by a given set of conditions or criteria.
Syntax
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
min_range (required) | The actual range of cells in which the minimum value will be determined.
criteria_range1 (required) | Is the set of cells to evaluate with the criteria.
criteria1 (required) | Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as minimum. The same set of criteria works for the MAXIFS, SUMIFS and AVERAGEIFS functions.
criteria_range2, criteria2, ...(optional) | Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs.
criteria_range1 (required) | Is the set of cells to evaluate with the criteria.
criteria1 (required) | Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as minimum. The same set of criteria works for the MAXIFS, SUMIFS and AVERAGEIFS functions.
criteria_range2, criteria2, ...(optional) | Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs.
Example
=MINIFS(A2:A7,B2:B7,1)
=MINIFS(A2:A5,B3:B6,"a")
=MINIFS(A2:A7,B2:B7,"b",D2:D7,">100")
=MINIFS(A2:A7,B2:B7,"b",D2:D7,A8)
=MINIFS(A2:A5,B2:C6,"a")
=MINIFS(A2:A6,B2:B6,"a",D2:D6,">200")
=MINIFS(A2:A5,B3:B6,"a")
=MINIFS(A2:A7,B2:B7,"b",D2:D7,">100")
=MINIFS(A2:A7,B2:B7,"b",D2:D7,A8)
=MINIFS(A2:A5,B2:C6,"a")
=MINIFS(A2:A6,B2:B6,"a",D2:D6,">200")