Excel FunctionsLesson 74Free preview
AVERAGEIF
This lesson is part of Excel · All levels
Summary
AVERAGE calculates the average only for cells that meet a certain requirement, for example, the average grade A value only. The structure is range, criteria, then optional average_range. The criteria can be numbers, text, or expressions such as ">70" written in quotation marks.
Key points
- Syntax: AVERAGEIF(range, criteria, [average_range])
- Only qualified cells are counted.
- Average_range is optional; when empty, the range is sorted
- Comparison criteria use quotation marks, such as ">70"
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.