AVEDEV | AVEDEV(number1, [number2], ...) |
AVERAGE | AVERAGE(number1, [number2], ...) |
AVERAGEA | AVERAGEA(value1, [value2], ...) |
AVERAGEIF | AVERAGEIF(range, criteria, [average_range]) |
AVERAGEIFS | AVERAGEIFS(avg_rng, range1, criteria1, [range2], [criteria2], ...) |
COMBIN | COMBIN(number, number_chosen) |
COUNT | COUNT(value1, [value2], ...) |
COUNTA | COUNTA(value1, [value2], ...) |
COUNTBLANK | COUNTBLANK(range) |
COUNTIF | COUNTIF(range, criteria) |
COUNTIFS | COUNTIFS(range1, criteria1, [range2], [criteria2], ...) |
DEVSQ | DEVSQ(number1, [number2], ...) |
FREQUENCY | FREQUENCY(data_array, bins_array) |
GEOMEAN | GEOMEAN(number1, [number2], ...) |
HARMEAN | HARMEAN(number1, [number2], ...) |
LARGE | LARGE(array, n) |
MAX | MAX(number1, [number2], ...) |
MAXA | MAXA(value1, [value2], ...) |
MAXIFS | MAXIFS(max_range, range1, criteria1, [range2], [criteria2], ...) |
MEDIAN | MEDIAN(number1, [number2], ...) |
MIN | MIN(number1, [number2], ...) |
MINA | MINA(value1, [value2], ...) |
MINIFS | MINIFS(min_range, range1, criteria1, [range2], [criteria2], ...) |
MODE | MODE(number1, [number2], ...) |
MODE.MULT | MODE.MULT(number1, [number2], ...) |
MODE.SNGL | MODE.SNGL(number1, [number2], ...) |
PERCENTILE | PERCENTILE(array, k) |
PERCENTILE.EXC | PERCENTILE.EXC(array, k) |
PERCENTILE.INC | PERCENTILE.INC(array, k) |
PERCENTRANK | PERCENTRANK(array, x, [significance]) |
PERCENTRANK.EXC | PERCENTILE.EXC(array, k) |
PERCENTRANK.INC | PERCENTILE.INC(array, k) |
PERMUT | PERMUT(number, number_chosen) |
QUARTILE | QUARTILE(array, quart) |
QUARTILE.EXC | QUARTILE.EXC(array, quart) |
QUARTILE.INC | QUARTILE.INC(array, quart) |
RANK | RANK(number, array, [order]) |
RANK.AVG | RANK.AVG(number,ref,[order]) |
RANK.EQ | RANK.EQ(number,ref,[order]) |
SMALL | SMALL(array, k) |
STANDARDIZE | STANDARDIZE(x, mean, standard_dev) |
STDEV | STDEV(number1,[number2],...) |
STDEV.P | STDEV.P(number1,[number2],...) |
STDEV.S | STDEV.S(number1,[number2],...) |
STDEVA | STDEVA(value1, [value2], ...) |
STDEVP | STDEVP(number1,[number2],...) |
STDEVPA | STDEVPA(value1, [value2], ...) |
TRIMMEAN | TRIMMEAN(array, percent) |
VAR | VAR(number1,[number2],...) |
VAR.P | VAR.P(number1,[number2],...) |
VAR.S | VAR.S(number1,[number2],...) |
VARA | VARA(value1, [value2], ...) |
VARP | VARP(number1,[number2],...) |
VARPA | VARPA(value1, [value2], ...) |