## Functions

A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

### Statistical Functions

The Excel Statistical functions are all listed in the tables below. Selecting a "Example" will take you to a full description of the function, with examples of use and advice on common errors. Note that some of the Statistical functions were introduced in recent versions of Excel, and so are not available in earlier versions.

Functions Syntax Tutorial
AVERAGE Function AVERAGE(number1, [number2],…) Example
AVERAGEIF Function AVERAGEIF(range, criteria, average_range) Example
AVERAGEIFS Function AVERAGEIFS(average_range, criteria1, criteria1 range,….) Example
COUNT Function COUNT(value1, [value2], …) Example
COUNTA Function COUNTA(value1, [value2], …) Example
COUNTBLANK Function COUNTBLANK(range) Example
COUNTIF Function COUNTIF(range, criteria) Example
COUNTIFS Function COUNTIFS(criteria_range1, criteria) Example
SMALL Function SMALL(array, k) Example
LARGE Function LARGE(array, k) Example
MAX Function MAX(number1, [number2], …) Example
MIN Function MIN(number1, [number2], …) Example
Excel MOD Function MOD(number, divisor) Example