These docs are for v1.0. Click to read the latest docs for v1.2.

MEAN

Calculates the mean (average) of specified numbers.

Syntax

=MEAN(number1, number2, ..., numberN)

=MEAN(numberArray)

Arguments

ArgumentTypeDescription
numberNumber or ArrayA 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).