MINIFS

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

Syntax

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

Arguments

Name	Type	Description
MinRange	Range	Cell-range to determine minimum value of.
CriterionRange1	Range	The cell-range which is checked against the criterion.
Criterion1	String	The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,... (optional)	Range	Additional cell-range which is checked against next criterion.
Criterion2,... (optional)	String	Additional criterion each cell of CriterionRange2 has to fulfill.

Return

Type	Description
Number	The minimum of all cell values which meet all specified criteria.

Examples

	A	B	C	D
1	89	1	a	1
2	93	2	b	2
3	96	2	a	3
4	85	3	b	4
5	91	1	b	5
6	88	1	a	6

Formula	Result	Comment
=MINIFS(A1:A6<, B1:B6, 1)	88	Minimum value of cells which have 1 in their B-column.
=MINIFS(A1:A6, C1:C6, "b", D6:D6, ">=2")	85	Minimum 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")	0	No cell fulfills given criterion.
=MINIFS(A1:A6, B1:D7, ">4")	#VALUE!	MinRange and CriteriaRange have different height and/or with.
Function	Result	Comment