|
<< Click to Display Table of Contents >> AVERAGE (arithmetic mean) |
Syntax:
AVERAGE(Number1 [, Number2, Number3 ...])
Description:
Returns the arithmetic mean of the given numbers.
This is calculated by dividing their sum by their number.
Number1, Number2, etc. are single values, cell ranges, or arrays containing the values to be evaluated.
If this function refers to empty cells, these are ignored. Also cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus be taken into account.
Example:
AVERAGE(1, 2, 6) equals (1+2+6) / 3, which is 3.
If cells A1 to A4 contain the values 0, 1, 2 and the logical value TRUE, the following applies:
AVERAGE(A1:A4) equals (0+1+2) / 3, thus returns 1. The cell with the logical value is not considered here – not even when determining the number of values.
AVERAGE(A1:A4, TRUE) equals (0+1+2+1) / 4, thus returns 1. Since the entered value TRUE is evaluated as 1, FALSE accordingly as 0.
See also: