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

    This function adds the cells using a given criteria.

    Syntax

    SUMIF(array,condition,sumrange)

    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
    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)
    sumrange [Optional] Range of cells to add; if omitted, then all the cells in the array are added

    Data Types

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

    Examples

    SUMIF(A1:B7,">150",C1:C11)

    SUMIF(A1:A9,">150")

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    SUMPRODUCT | SUM | COUNTIF | Math and Trigonometry Functions