46
User Manual
Function Name
Explanations
TRUE evaluates as 1
COUNT(value1,value2,...)
Calculates the number of references or cell range
COUNTA(value1, value2, ...)
The COUNTA function counts the number of
cells that are not empty in a range
COUNTBLANK(range)
Counts empty cells in a specified range of cells.
COUNTIF(range, criteria)
The COUNTIF function counts the number of
cells within a range that meet a single criterion
that you specify.
LARGE(array, k)
Returns the k-th largest value in a data set.
LINEST(known_y’s, known_x’s, const,
stats)
Returns numeric array
MAX(number1,number2, ...)
Returns the largest value in a set of values
(ignore text values and logical values)
MAXA(number1,number2, ...)
Returns the largest value in a list of arguments.
(ignore text values and logical values)
MIN(number1,number2, ...)
Returns the smallest number in a set of values.
(ignore text values and logical values)
MINA(number1,number2, ...)
Returns the smallest value in a list of arguments.
(ignore text values and logical values)
MODE(number1,number2, ...)
Returns the most frequently occurring, or
repetitive, value in an array or range of data.
RANK(number, ref, order)
Returns the rank of a number in a list of
numbers.
SMALL(array, k)
Returns the k-th smallest value in a data set.
STDEV(number1,number2, ...)
Estimates standard deviation based on a sample.
(ignore text values and logical values)
STDEVP(number1,number2, ...)
Calculates standard deviation based on the entire
population given as arguments. (ignore text