Average

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.
Syntax:
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)
Remarks:
Empty cells are considered as 0 in calculations.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk