Excel AVERAGE Function (Example + Video)
When to use Excel AVERAGE Function
AVERAGE function can be used when you want to get the average (arithmetic mean) of the specified arguments.
What it Returns
It returns a number that represents the average (arithmetic mean) of the arguments.
Syntax
=AVERAGE(number1, [number2], …)
Input Arguments
- number1 – the first number, cell reference, or range for which you want the average.
- [number2] – (Optional) the second number, cell reference or range for which you want the average. There can be a maximum of up to 255 additional arguments.
Additional Notes
- Arguments can be numbers, named ranges, or cell references that contain numbers.
- Cells references with text, logical values, or empty cells are ignored, but cells with 0 are counted for averaging
- Logical values and text representations of numbers that you type directly into the list of arguments are counted.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
Excel AVERAGE Function – Video Tutorial
You May Like the Following Excel Tutorials:
Related Excel Functions:
