Spread Formula Reference
MINIFS
Formula Functions > Functions M to Q > MINIFS

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.

Syntax

MINIFS(max_range, range1, critera1, [range2,criteria2],..)

Arguments

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

Remarks

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.

Data Types

Accepts either numeric data, expression, or text for all arguments. Returns numeric data.

Examples

MINIFS(A3:A7,B3:B7,23) gives the result 0.

MINIFS(A3:A7,B3:B7,325) gives the result 325.

Version Available

This function is available in Spread for Windows Forms 11.0 or later.