Description of formula:
Calculates the arithmetic mean of the specified values. You can pass any number of arguments of type Number, arrays of values or cell ranges.
Calculates the arithmetic mean of the specified values. You can pass any number of arguments of type Number, arrays of values or cell ranges.
Syntax:
average(values, ...)
average(values, ...)
Parameters:
values
(type: Number / array of Numbers) (multiple parameter) Numbers from which the average should be calculated
Returned type:
Number
Examples:
=average(A1:A16)
=average(section1.A)
=average(1,12,34,23)
=average(B3,B4,B5,B7)
=average(A1:A16)
=average(section1.A)
=average(1,12,34,23)
=average(B3,B4,B5,B7)
Remarks:
Empty cells are considered as 0 in calculations.
Empty cells are considered as 0 in calculations.
0 Comments