Excel FunctionsLesson 73Free preview
AVERAGE
This lesson is part of Excel · All levels
Summary
AVERAGE calculates the arithmetic mean of a set of numbers, that is, the total divided by the number of cells containing the numbers. Empty cells and text are passed so the result remains logical. This function is very common for daily performance scores, scores, and metrics.
Key points
- Formula: the sum of the values divided by the number of number cells
- Empty cells and text are not counted in the numerator or denominator
- Can accept many arguments and ranges at once
- If all the cells are not numbers, the result is 0!
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.