Statistical Functions

On this page, you'll find the most commonly used statistical functions, each demonstrated in a simple example.

Statistical Functions

AVERAGETake the average of a set of values
COUNTCalculate the number of cells containing numbers
COUNTACalculate the number of non-empty cells
COUNTBLANKCalculate the number of empty cells
COUNTIFCalculate the number of cells that contain a specified value
FORECASTExtrapolate based on known data
MAXReturn the greatest value
MINReturn the least value
RANKClassify a value based on a series of values