This function returns the minimum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.
MINIFS(max_range, range1, critera1, [range2,criteria2],..)
This function has the following arguments:
Argument | Description |
---|---|
min_range | Refers to the range of cells in which minimum will be calculated |
range1 | Refers to the set of cells to be calculated based on criteria |
criteria1 | Refers to the criteria (in term of number, expression, or text) according to which cells will be calculated |
range2, criteria2... | [Optional] Refers to the additional ranges and thier corresponding criteria |
If the size and shape of min_range and rangeN (refers to range1,2,3,4,......N) arguments is not same, this function will return the #VALUE! error.
If cells do not match with the specified criteria, this function will return 0.
Accepts either numeric data, expression, or text for all arguments. Returns numeric data.
MINIFS(A3:A7,B3:B7,23) gives the result 0.
MINIFS(A3:A7,B3:B7,325) gives the result 325.