AVERAGE function

AVERAGE(firstParameter, otherParameters...) AVERAGE(firstParameter; otherParameters...)

firstParameter — Number or { Number }

The first parameter.

otherParameters — Number or { Number } (accepts many)

Additional parameters.

Returns — Number

The average of the parameters.

Returns the average (arithmetic mean) of the parameters. AVERAGE(2, 6, 4)AVERAGE(2; 6; 4) returns 4.

AVERAGE only accepts numbers and number arrays. Use AVERAGEA instead of you also need to evaluate logical values and text strings representing numbers. Use TRIMMEAN to discard a percentage of the smallest and largest elements of the array before calculating the average.

Use AVERAGEIF or AVERAGEIFS to only consider values satisfying one or several conditions.

Examples

AVERAGE(2, 6, 4)AVERAGE(2; 6; 4)

Returns 4, the average of the three parameters.

AVERAGE(2, 6, BLANK(), 4)AVERAGE(2; 6; BLANK(); 4)

Returns 4, the average of the three parameters. Blank values are ignored.

AVERAGE(2, { 6, BLANK() }, 4)AVERAGE(2; { 6; BLANK() }; 4)

Returns 4, the average of the three given numbers. Arrays are also supported. Blank values are ignored.