Skip to main content

MINIFS

Returns the minimum value of all cells which meet multiple criteria.

Syntax

=MINIFS(MinRange, CriterionRange1, Criterion1, [CriterionRange2, Criterion2], ...)

Arguments

NameDescription
MinRangeCell-range to determine minimum value of.
CriterionRange1The cell-range which is checked against the criterion.
Criterion1The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,...Optional. Additional cell-range which is checked against next criterion.
Criterion2,...Optional. Additional criterion each cell of CriterionRange2 has to fulfill.

Return Value

The mminimum of all cell values which meet all specified criteria.

Example

ABCD
1891a1
2932b2
3962a3
4853b4
5911b5
6881a6
FunctionResultComment
MINIFS(A1:A6, B1:B6, 1)88Minimum value of cells which have 1 in their B-column.
MINIFS(A1:A6, C1:C6, "b", D6:D6, ">=2")85Minimum value of all cells which have "b" in their C-column and its D-column value is greater or equal 2.
MINIFS(A1:A6, B1:B6, ">4")0No cell fulfills given criterion.
MINIFS(A1:A6, B1:D7, ">4")#VALUE!MinRange and CriteriaRange have different height and/or with.