# AVERAGE function

AVERAGE(First, Other...) AVERAGE(First; Other...)

## First

Number or { Number }

The first parameter.

## Other

Number or { Number } (accepts many)

## 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.

AVERAGE(Employees!Salary)AVERAGE(Employees!Salary)

Returns the average salary of all employees. Salary is a named value, belonging to the Employees screen, whose formula is an array specifying the contents of this table column. The named value and its formula can be created and maintained using a spreadsheet-like editor in Calcapp Creator.