AVERAGEIF()

Syntax AVERAGEIF(range,criteria,average_range)

Note

The AVERAGEIF() function was new in Excel 2007.

Definition. This function calculates the average of all cells in a range that meet a specified criterion.

Arguments

  • range (required). One or more cells to average, including numbers, names, arrays, or references that contain numbers.

  • criteria (required). The criteria—in the form of a number, an expression, a cell reference, or text—that define which cells are averaged.

  • average_range (optional). The actual set of cells to average. If average_range is not specified, range is used.

Note

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 empty or is a text value, ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial