SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / MINIFS
In This Topic
    In This Topic

    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.

    Data Types

    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.

    See Also