| AVERAGE |
Get the average of a group of numbers |
number1number2 … |
| AVERAGEA |
Get the average of a group of numbers and text |
value1value2 … |
| AVERAGEIF |
Get the average of numbers that meet criteria |
range criteriaaverage_range |
| COUNT |
Count numbers |
value1value2 … |
| COUNTA |
Count the number of non-blank cells |
value1value2 … |
| COUNTBLANK |
excel-countblank-function |
range |
| COUNTIF |
Count cells that match criteria |
range criteria |
| COUNTIFS |
Count cells that match multiple criteria |
range1 criteria1range2 criteria2 … |
| FREQUENCY |
Get the frequency of values in a data set |
data_array bins_array |
| LARGE |
Get the nth largest value |
array n |
| MEDIAN |
Get the median of a group of numbers |
number1numer2 … |
| MIN |
Get the smallest value. |
array |
| MODE |
Get the mode of a group of numbers |
number1number2 … |
| RANK |
Rank a number against a range of numbers |
number arrayorder |
| SMALL |
Get the nth smallest value |
array n |
| STDEV |
Get the standard deviation in a sample |
number1number2 … |
| STDEV.P |
Get standard deviation of population |
number1number2 … |
| STDEV.S |
Get the standard deviation in a sample |
number1number2 … |
| STDEVP |
Get standard deviation of population |
number1number2 … |
