Spread Formula Reference
Formula Functions / Functions M to Q / MAXIFS
In This Topic
    MAXIFS
    In This Topic

    This function returns the maximum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.

    Syntax

    MAXIFS(max_range, range1, criteria1, [range2,criteria2],..)

    Arguments

    This function has the following arguments:

    Argument Description
    max_range Refers to the range of cells in which maximum will be calculated
    range1 Refers to the set of cells to be calculated based on the criteria
    criteria1 Refers to the criteria (in terms of number, expression, or text) according to which cells will be calculated
    range2, criteria2... [Optional] Refers to the additional ranges and their corresponding criteria

    Remarks

    If the size and shape of max_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

    MAXIFS(C4:C7,B4:B7,"325") gives the result 656

    MAXIFS(C4:C7,B4:B7,"55") gives the result 0

    Version Available

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