MINIFS¶
Returns the minimum value of all cells which meet multiple criteria.
Syntax
=MINIFS(MinRange, CriterionRange1, Criterion1, [CriterionRange2, Criterion2], …)
Arguments
Name 
Description 

MinRange 
Cellrange to determine minimum value of. 
CriterionRange1 
The cellrange which is checked against the criterion. 
Criterion1 
The criterion each cell of CriterionRange1 has to fulfill. 
CriterionRange2,… 
Optional. Additional cellrange 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
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 
Function 
Result 
Comment 

MINIFS(A1:A6, B1:B6, 1) 
88 
Minimum value of cells which have 1 in their Bcolumn. 
MINIFS(A1:A6, C1:C6, “b”, D6:D6, “>=2”) 
85 
Minimum value of all cells which have “b” in their Ccolumn and its Dcolumn 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. 