Reference
No results for 'undefined'
    Powered by Algolia

    AVERAGEIFS

    Returns the average (arithmetic mean) of all cells that meet multiple criterias

    Syntax

    =AVERAGEIFS(count_range, criterias, criterias, ...)

    Parameters

    1. count_range
      • Type: Range
      • Description: Set of cells to calculate average.
    2. criterias [repeatable]
      • Type: Any
      • Description: Ranges and criterias to apply. All ranges must be of the same size. 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.

    Returns

    • Type: Any
    • Description: Average of the values in a range that meet criterias specified

    Example

    =AVERAGEIFS(A1:A12,B1:B12,">10", C1:C12,"Tom")
    Contents