|
<< Click to Display Table of Contents >> AVERAGE (arithmetic mean) |
Syntax:
AVERAGE(Number1 [, Number2, Number3 ...])
Description:
This 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 that contain the values to be evaluated.
If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.
Example:
AVERAGE(1, 2, 6) equals (1+2+6) / 3, which is 3.
If the cells A1:A4 contain the values 0, 1, 2 and the logical value TRUE, the following applies:
AVERAGE(A1:A4) equals (0+1+2) / 3, which is 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, which is 1. Since the entered value TRUE is evaluated as 1, FALSE is evaluated as 0 accordingly.
See also: