Excel FunctionsLesson 75Free preview
AVERAGEIFS
This lesson is part of Excel · All levels
Summary
AVERAGEIFS is an advanced version that supports several criteria at once, for example the average sales of a particular product in a particular region. Unlike AVERAGEIF, the order is preceded by average_range and then the criteria_range and repeat criteria pair. All criteria must be met at once.
Key points
- Syntax: AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
- Supports two or more criteria at once
- All criteria must be met.
- The length of each criteria_range should be equal to the average_range
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.