Excel function category
Excel Statistical Functions
Reference pages for formulas that count, average, summarize, and analyze worksheet data with practical criteria-based examples.
8 functions
AVERAGE
Statistical
Return the arithmetic mean of the numbers in a range or list of values.
Syntax
AVERAGE(number1, [number2], ...)AVERAGEIF
Statistical
Return the average of values that meet one condition.
Syntax
AVERAGEIF(range, criteria, [average_range])AVERAGEIFS
Statistical
Return the average of values that meet multiple conditions.
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)COUNT
Statistical
Count how many cells contain numeric values.
Syntax
COUNT(value1, [value2], ...)COUNTA
Statistical
Count how many cells are not empty.
Syntax
COUNTA(value1, [value2], ...)COUNTBLANK
Statistical
Count how many blank cells are in a range.
Syntax
COUNTBLANK(range)COUNTIF
Statistical
Count the number of cells in a range that meet a single condition.
Syntax
COUNTIF(range, criteria)COUNTIFS
Statistical
Count how many rows meet multiple criteria.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)