Statistical

Statistical
Function Purpose Param,Optional
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

Excel - Excel Functions - Excel Formulas
Logo