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.