AVERAGE

Calculates the arithmetic mean of multiple values or cell references to quickly summarize and analyze data.

The AVERAGE function returns the average (arithmetic mean) of a set of values by adding all the numbers together and dividing the result by the total count of values. The arguments can be numeric values or cell references. This function is commonly used to analyze data trends, compare performance, and summarize datasets by providing a single representative value.

Syntax

AVERAGE(value1,[value2]....)

Arguments

value1 – The first node or number to average (Required).

value2,...– The additional nodes or numbers to be averaged (optional).

Example

AVERAGE(COLUMN1, COLUMN2)

In the example below, the Average Values measure is created using the AVERAGE function to return the average value of the data from the four quarters.

Applying AVERAGE function

Excel equivalent

AVERAGE