Reference
No results for 'undefined'
    Powered by Algolia

    AVERAGEIF

    Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

    Syntax

    =AVERAGEIF(criteria_range, criteria, [average_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. average_range [optional]
      • Type: Range
      • Description: Optional. The actual set of cells to average. If omitted, range is used

    Returns

    • Type: Any
    • Description: Average (arithmetic mean) of all the cells in a range that meet a given criteria

    Example

    =AVERAGEIF(A1:A12,">10")
    Contents