Reference
No results for 'undefined'
    Powered by Algolia

    SUMIF

    Applies criteria to cells across range and sum the values in a range that meet criteria specified

    Syntax

    =SUMIF(criteria_range, criteria, [sum_range])

    Parameters

    1. criteria_range
      • Type: Range
      • Description: The range in which to evaluate the associated criteria
    2. criteria
      • Type: String
      • Description: The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. Criteria aren't case sensitive. In other words, the string "apples" and the string "APPLES" will match the same cells. Wildcard characters —the question mark (?) and asterisk (*)—can be used in criteria. A question mark matches any single character. An asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) in front of the character.
    3. sum_range [optional]
      • Type: Range
      • Description: Optional. The actual set of cells to sum. If omitted, range is used

    Returns

    • Type: Any
    • Description: Sum of the values in a range that meet criteria specified

    Example

    =SUMIF(A1:A12,">10")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents