Calculate the arithmetic mean of a range of numbers.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
AVERAGE(number1, [number2], …)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)Result: 84.3
Returns the mean of all scores in the range.
No — blanks are ignored. But cells containing 0 are counted, which lowers the mean.