Excel functions, formulas and examples

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 9: Excel Spreadsheets Statistical Functions (83)

In annex 9 you have found a description of all 83 Excel functions in the "Statistical" category. Below is the list of the 7 most useful ones. See more on the obsolete function COUNTIF in lesson 14, more on the MIN, MAX, SMALL, LARGE functions in lesson 20 and more on the 3 new 2007 Excel functions COUNTIFS, AVERAGEIF and AVERAGEIFS in lessons 23, 21 and 22.

Functions	What it Does
AVERAGE	Returns the average of its arguments
COUNT	Counts how many numbers are in the list of arguments
AVERAGEA	Returns the average of its arguments, including numbers, text, and logical values
COUNTA	Counts how many values are in the list of arguments)
RANK	Returns the rank of a number in a list of numbers
LARGE	Returns the k-th largest value in a data set
SMALL	Returns the k-th smallest value in a data set
New Functions in Excel 2007
AVERAGEIF	Calculates the average within a range that meet a given criteria (SUMPRODUCT does better)
AVERAGEIFS	Calculates the average within a range that meet one or many given criteria (SUMPRODUCT does better)
COUNTIFS	Counts the number of nonblank cells within a range that meet the given criteria (SUMPRODUCT does better)

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

Go to the next lesson:
Lesson 10: Excel Text Functions