Share this article:

What it does: The AVERAGE() Function finds the average of the numbers (arguments) you provide.

Plain English: The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be individual, in an array, or named range.

Arguments: Average(number1,[number2])

  • Number 1 – the first number for which you want the average
  • Number 2 – optional – the second number for which you want the average.