Skip to main content

MINIFS

Returns the minimum value among cells that meet one or more criteria.

CategoryAggregate
SyntaxMINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Parameters

ParameterRequiredDescription
min_rangeRequiredThe range of cells to find the minimum in.
criteria_range1RequiredThe first range to evaluate.
criteria1RequiredThe criteria to apply to criteria_range1.
criteria_range2OptionalAdditional range to evaluate.
criteria2OptionalCriteria to apply to criteria_range2.

Example

MINIFS(range, criteria)

Auto-generated from the EngCanvas function registry.