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 … |