The AVERAGE Function: Syntax and Examples

Excel AVERAGE FunctioN

The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003.

Note: the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median, use the MEDIAN function.

Syntax

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

Required Arguments

number1: Arguments can either be numbers or names, arrays, or references that contain numbers, which means 5, A2 and C4:C8 are all valid examples.

Optional Arguments

number2-255: You can use up to 255 numbers in the calculation by following the syntax listed above.

Note: If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.

AVERAGE Function Examples

Using AVERAGE when some cells contain text

If some cells in your range contain text, logical values or are empty, Excel will just ignore them when calculating the average.

Keep in mind that the outcome can be very different with cells that contain 0 or are left empty.

AVERAGE function example 1

AVERAGE with cell ranges

AVERAGE function example 2

More Examples and Use Cases

We don’t have any use cases for this formula on our website at this moment but will link them below once we have. Stay tuned!

Leave a Reply

Your email address will not be published. Required fields are marked *