How to Use Excel AVERAGEIFS Function (Examples + Video)

Excel AVERAGEIFS Function (Example + Video)

Excel Averageifs Function

When to use Excel AVERAGEIFS Function

Excel AVERAGEIFS function can be used when you want to get the average (arithmetic mean) of all the cells in a range that meets multiple criteria.

What it Returns

It returns a number that represents the average (arithmetic mean) of the arguments.

Syntax

=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …).

Input Arguments

  • average_range – the range of cells you want to average.
  • criteria_range1, criteria_range2,.. – the ranges against which the criteria are evaluated. There can be up to 127 ranges and associated criteria.
  • criteria1, criteria2,.. – the criteria that is applied to its associated range. For example, criteria1 is applied to criteria_range1, criteria2 is applied to criteria_range2, and so on..

Additional Notes

  • If there are blanks or text in average_range, it returns a #DIV/0! error.
  • Criteria could be a number, expression, cell reference, text, or a formula.
    • Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes.
    • Wildcard characters can be used in criteria.
  • Cells in average_range are averaged only when all the conditions are met.
  • Range size of average_range and all the criteria_range must be equal.

Excel AVERAGEIFS Function – Live Example

Excel AVERAGEIFS Function – Video Tutorial

Related Excel Functions:

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)