# Excel statistical functions

> Statistical functions summarize a list of numbers: the typical value, the spread, the top and bottom entries, and how many cells hold data.

Source: https://spreadsheetpractice.com/functions/category/stats · Updated October 29, 2026

Statistical functions summarize a list of numbers: the typical value, the spread, the top and bottom entries, and how many cells hold data. Most of them skip text and empty cells in a range, which is usually what you want and occasionally the reason a result looks off.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Find the typical value | [AVERAGE](https://spreadsheetpractice.com/functions/average) | Adds the numbers and divides by how many there are. Zeros count; blanks and text don't. |
| Find the typical value when a few numbers are extreme | [MEDIAN](https://spreadsheetpractice.com/functions/median) | The middle value isn't pulled around by one huge or tiny number the way an average is. |
| Pull the top or bottom few values | [LARGE](https://spreadsheetpractice.com/functions/large) | LARGE and SMALL return the 1st, 2nd, 3rd largest or smallest value, so you can build a top-3 list. |
| Rank a list from best to worst | [RANK.EQ](https://spreadsheetpractice.com/functions/rank-eq) | RANK.EQ gives each value its position, and tied values share a rank. |
| Measure how consistent the numbers are | [STDEV](https://spreadsheetpractice.com/functions/stdev) | A larger standard deviation means the values are more spread out. |
| Count cells that hold numbers, anything, or nothing | [COUNTA](https://spreadsheetpractice.com/functions/counta) | COUNT counts numbers, COUNTA counts any entry, and COUNTBLANK counts the gaps. |

## All 19 statistical functions

| Function | What it does | Available in |
|---|---|---|
| [AVERAGE](https://spreadsheetpractice.com/functions/average) | AVERAGE adds up the numbers you give it and divides by how many numbers there are. | Every current version |
| [COUNT](https://spreadsheetpractice.com/functions/count) | COUNT tells you how many cells contain numbers. | Every current version |
| [COUNTA](https://spreadsheetpractice.com/functions/counta) | COUNTA counts every cell that isn't empty: text, numbers, dates, errors and even formulas that return empty text. | Every current version |
| [COUNTBLANK](https://spreadsheetpractice.com/functions/countblank) | COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates. | Every current version |
| [LARGE](https://spreadsheetpractice.com/functions/large) | LARGE returns the k-th largest value in a range: k = 1 is the largest, 2 the second largest, and so on. | Every current version |
| [MAX](https://spreadsheetpractice.com/functions/max) | MAX returns the largest number from a list of values or ranges: the top sale, the latest date, the highest temperature. | Every current version |
| [MEDIAN](https://spreadsheetpractice.com/functions/median) | MEDIAN returns the middle value once the numbers are sorted. | Every current version |
| [MIN](https://spreadsheetpractice.com/functions/min) | MIN returns the smallest number from a list of values or ranges. | Every current version |
| [MODE](https://spreadsheetpractice.com/functions/mode) | MODE returns the number that appears most often in a list, such as the most common shoe size or order quantity. | Every current version |
| [PERCENTILE.EXC](https://spreadsheetpractice.com/functions/percentile-exc) | PERCENTILE.EXC returns the value at a given percentile using the exclusive method, which leaves out the very bottom and top of the range: k must sit strictly between 0 and 1, and close to the ends of a short list it returns #NUM!. | Excel 2010 and later |
| [PERCENTILE.INC](https://spreadsheetpractice.com/functions/percentile-inc) | PERCENTILE.INC returns the value below which a given share of the data falls: k = 0.9 gives the 90th percentile. | Excel 2010 and later |
| [PERCENTRANK.INC](https://spreadsheetpractice.com/functions/percentrank-inc) | PERCENTRANK.INC tells you where a value stands in a list, from 0 for the lowest to 1 for the highest: 0.75 means it is above 75% of the other values. | Excel 2010 and later |
| [QUARTILE.EXC](https://spreadsheetpractice.com/functions/quartile-exc) | QUARTILE.EXC returns the first, second or third quartile using the exclusive method, which some statistics tools and textbooks use. | Excel 2010 and later |
| [QUARTILE.INC](https://spreadsheetpractice.com/functions/quartile-inc) | QUARTILE.INC returns a quartile of a set of numbers: 1 for the first quartile (the 25th percentile), 2 for the median, 3 for the third quartile, and 0 and 4 for the minimum and maximum. | Excel 2010 and later |
| [RANK.EQ](https://spreadsheetpractice.com/functions/rank-eq) | RANK.EQ tells you where a number places within a list: 1 for the largest by default, or 1 for the smallest if you set the order to 1. | Excel 2010 and later |
| [SMALL](https://spreadsheetpractice.com/functions/small) | SMALL returns the k-th smallest value in a range: k = 1 is the smallest, 2 the second smallest, and so on. | Every current version |
| [STDEV](https://spreadsheetpractice.com/functions/stdev) | STDEV measures how spread out a set of numbers is, treating them as a sample of a larger group. | Every current version |
| [STDEV.P](https://spreadsheetpractice.com/functions/stdev-p) | STDEV.P measures how spread out a set of numbers is when those numbers are the entire population: every employee, every shift, every student in the class. | Excel 2010 and later |
| [VAR](https://spreadsheetpractice.com/functions/var) | VAR returns the variance of a sample: the average squared distance of each value from the mean. | Every current version |

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
