Statistical Functions

Statistical functions allow you to calculate averages, minimum and maximum values, standard deviations, and variances. They also allow you to count the number of values in a list or range of cells.

AVERAGE (number1, number2, ...): Returns the average of the specified numbers.

MAX (number_list): Returns the largest value in the specified list of numbers.

MIN (number_list): Returns the smallest value in the specified list of numbers.

STDEV (number_list): Returns the standard deviation of a population based on a sample of values. The standard deviation of a population represents an average of deviations from the population mean within a list of values. This list must contain at least two numbers.

STDEVP (number_list): Returns the standard deviation of a population based on an entire population of values. The standard deviation of a population represents an average of deviations from the population mean within a list of values. This list must contain at least two numbers.

VAR (number_list): Returns the variance of a population based on a sample of values. This list must contain at least two numbers.

VARP (number_list): Returns the variance of a population based on the entire population. This list must contain at least two numbers.

 

Counting Functions

COUNT (value_list): Returns the number of values in the specified list.

COUNTA (expression_list): Returns the number of nonblank values in the specified list.

COUNTIF (range, criteria): Returns the number of cells within the range that meet the specified criteria. This criteria can be a numerical value (e.g., 50), a text string (e.g., "No"), a logical expression (">0"). Note that text strings and expressions must be enclosed in double quotes.

Examples:

 

A

1

80

2

45

3

76

4

68

5

N/A

6

 

 

Formula

Result

=COUNT(A1:A4)

4

=COUNT(A1:A4)

4 (only cells containing numerical values are counted)

=COUNTA(A1:A5)

5

=COUNTA(A1:A6)

5 (blank cells are not counted)

=COUNTIF(A1:A4, ">50")

3