MEAN
Calculates the mean (average) of specified numbers.
Syntax
=MEAN(number1, number2, ..., numberN)
=MEAN(numberArray)
Arguments
| Argument | Type | Description |
|---|---|---|
| number | Number or Array | A number or array of numbers to average |
If an array of values is supplied, the array will be flattened when averaging. For example,
=MEAN(ARRAY(1,ARRAY(2,3)),ARRAY(4,5),6)returns 3.5 ((1 + 2 + 3 + 4 + 5 + 6) / 6).
Examples
=MEAN(1,2,3) → 2
Calculates the mean of 1, 2, and 3.
=MEAN(ARRAY(4,5),6) → 5
Calculates the mean of any array containing 4, 5 and the number 6. Because the MEAN function flattens arrays, this is the same as the mean of 4, 5, and 6.
=MEAN(children."Property 1") → 4.666
Calculates the mean of all children's data property values for "Property 1" (1, 4, 2, 6, 7, 8).
Updated 8 months ago