O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

AVERAGEIFS()

Syntax. AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2,...)

Note

The AVERAGEIFS() function was new in Excel 2007.

Definition. This function returns the average of all cells that meet several criteria.

Arguments

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

  • criteria_range1 (required). The range in which to evaluate the associated criteria

  • criteria1 (required). The criteria in the form of a number, an expression, a cell reference, or text that defines which cells will be averaged

  • criteria_range2 (optional). At least one and up to 127 ranges containing the criteria to be evaluated

  • criteria2 (optional). At least one and up to 127 criteria ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required