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 |