Spread Formula Reference
Formula Functions / Functions R to S / SUMIFS
In This Topic
    SUMIFS
    In This Topic

    This function adds the cells in a range using multiple criteria.

    Syntax

    SUMIFS(array,conditionarray,condition,...)

    Arguments

    This function has these arguments:

    Argument Description
    array Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value
    conditionarray Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value
    condition Condition that determines which cells are added, as a text, number, or expression (where expressions use the relational operators detailed in Operators in a Formula)

    Data Types

    Accepts numeric data for array. Accepts text, numeric or expression data for condition. Returns numeric data.

    Examples

    SUMIFS(A1:A10, B1:B10,">0",C1:C10,"<10")

    Version Available

    This function is available in product version 5.0 or later.

    See Also

    SUMPRODUCT | SUM | COUNTIF | Math and Trigonometry Functions