sum
Returns the numeric total.average
Returns the arithmetic mean, or null when no values exist.average in new formulas. The older name avg remains accepted.
min and max
Return the smallest or largest value, or null when no values exist.count
Counts non-empty values of any type. It behaves like ExcelCOUNTA, not Excel COUNT.
first and last
Return the first or last value in the selected series order, or null when the series is empty.median
Returns the middle numeric value, or the midpoint of the two middle values, or null when no values exist.stdev
Returns sample standard deviation. It returns null with fewer than two values.stdev in new formulas. The older name stddev remains accepted.
var
Returns sample variance. It returns null with fewer than two values.var in new formulas. The older name variance remains accepted.