Formula Library

AVERAGE

math

Calculates the arithmetic mean of a range of numbers.

Syntax

=AVERAGE(number1, [number2, ...])

Example

Excel
=AVERAGE(B2:B100)

Calculates the average of all numeric values in cells B2 through B100.

Tips & Notes

  • →Ignores blank cells and text
  • →Use AVERAGEIF for conditional averages
  • →AVERAGEA includes logical values

See Also

AVERAGEIFSUMIF

Need a custom AVERAGE formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.