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 |