AVERAGE function

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


Number or { Number }

The first parameter.


Number or { Number } (accepts many)

Additional parameters.



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.


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.


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.