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:

Other Excel tutorials you may find useful:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment