MINIFS
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], ...)
Parameters
- min_range: Required. The actual range of cells in which the minimum will be determined
- criteria_range1: Required. The set of cells to evaluate
- criteria1: Required. The criteria
- criteria_range2: Optional. Additional ranges
- criteria2: Optional. Additional criteria
Example
=MINIFS(A1:A10, B1:B10, ">5")