Calculate the arithmetic mean of a range of numbers.
Syntax
AVERAGE(number1, [number2], …)Arguments
number1required
The first number, cell, or range.
number2…optional
Additional numbers or ranges.
AVERAGE returns the mean of the numbers you give it, ignoring blanks and text. For a conditional average, use AVERAGEIF; to include only some rows, combine with a filter.
=AVERAGE(C2:C100)→84.3Returns the mean of all scores in the range.
Select the numbers
Highlight the range to average.
Mind blanks vs zeros
AVERAGE skips blanks but counts zeros — clean your data if zeros shouldn't count.
No — blanks are ignored. But cells containing 0 are counted, which lowers the mean.