Statistical Functions

Function Basics	Insert Function	AutoSum	IF Function
PMT Function	Date Functions	DATEDIF Function	Lookup Functions
New 07 Functions	Time Functions	Text Functions	Rounding Functions
Stat Functions	Other Functions	SUBTOTAL (.xls)	SUMPRODUCT (.xls)

To see samples of the statistical functions, download functionsamples07.xls (2007) or functionsamples.xls (2003). They really need a decent table to be fully appreciated!

AVERAGE: Syntax: AVERAGE(number1, number2,...) or AVERAGE(range)
Returns the average (arithmetic mean) of the arguments.

MAX: Syntax: MAX(number1, number2,...) or MAX(range)
Returns the largest value in a set of values.

MIN: Syntax: MIN(number1, number2,...) or MIN(range)
Returns the smallest number in a set of values.

COUNT: Syntax: COUNT(value1, value2,...) or COUNT(range)
Counts the number of cells that contain numbers.

COUNTA: Syntax: COUNTA(value1, value2,...) or COUNTA(range)
Counts the number of cells that are not empty.

SUMIF: Syntax: SUMIF(range, criteria, range to sum)
Sum the values in a range that meet specified criteria.

COUNTIF: Syntax: COUNTIF(range, criteria)
Count the values in a range that meet specified criteria.

AVERAGEIF: Syntax: AVERAGEIF(range, criteria, range to average)
Average the values in a range that meet specified criteria.

Download the sample workbook functionsamples.xls or for 2007 users functionsamples07.xls.

Return to the Top