First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
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
Returns 4, the average of the three parameters.
Returns 4, the average of the three parameters. Blank values are ignored.
First
The first temporal value or array of temporal values.
Other
Additional temporal values or arrays of temporal values.
Returns
The temporal value midway between the given temporal values.
Returns the temporal value midway between the given temporal values. AVERAGE (StartDate, EndDate) AVERAGE (StartDate; EndDate) returns the midpoint of the period delimited by the two dates.
Unlike numbers, temporal values cannot be added together, as the sum of two points in time is not meaningful. The average of a number of temporal values is meaningful, though, as it is the point in time midway between them, which is why this overloaded function is provided. The SUM function, on the other hand, does not accept temporal values.