How To Use:Excel AverageIF Function -SIMPLIFIED

  • Published on May 13, 2016
  • Excel AverageIF Function
    It Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
    AVERAGEIF(range, criteria, [average_range])
    The AVERAGEIF function syntax has the following arguments:
    Range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
    Criteria Required. The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.
    Average_range: Optional. The actual set of cells to average. If omitted, range is use.

    Cells in range that contain TRUE or FALSE are ignored.
    If a cell in average_range is an empty cell, AVERAGEIF ignores it.
    If range is a blank or text value, AVERAGEIF returns the #DIV0! error value.
    If a cell in criteria is empty, AVERAGEIF treats it as a 0 value.
    If no cells in the range meet the criteria, AVERAGEIF returns the #DIV/0! error value.
    You can use the wildcard characters, question mark (?) and asterisk (*), 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 (~) before the character.
    Average_range does not have to be the same size and shape as range. The actual cells that are averaged are determined by using the top, left cell in average_range as the beginning cell, and then including cells that correspond in size and shape to range.
    1. Double-click the cell and type in the formula.
    2. After you finish typing the formula, just press enter
    and the result is displayed.
    Thanks for watching.
    Do subscribe to our channel.

Comments • 0