# MODE function in Excel

> MODE returns the number that appears most often in a list, such as the most common shoe size or order quantity.

Source: https://spreadsheetpractice.com/functions/mode · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** MODE returns the number that appears most often in a list, such as the most common shoe size or order quantity.
- **Syntax:** `=MODE(number1, [number2], ...)`
- **Most common use:** `=MODE(B2:B8)` returns 9 (Size 9 sold most often)
- **Available in:** Every current version
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The most frequent number. If several are tied, the one that appears first.
- **Google Sheets:** Also available in Google Sheets.

## What it does

MODE returns the number that appears most often in a list, such as the most common shoe size or order quantity. If no number repeats, it returns #N/A. Newer versions call it MODE.SNGL; MODE still works the same way and is kept for compatibility.

## Syntax

`=MODE(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range. |
| `number2` | Optional | More numbers, cells or ranges, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=MODE(B2:B8)` | 9 | Size 9 sold most often |
| F3 | `=MODE(C2:C8)` | #N/A | No rating repeats, so MODE returns #N/A |
| F4 | `=IFERROR(MODE(C2:C8),"No repeat")` | No repeat | IFERROR replaces the #N/A with a message |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order | Shoe size | Rating |  | Check | Result |
| 2 | S-01 | 9 | 7 |  | Most common size | 9 |
| 3 | S-02 | 10 | 4 |  | Ratings | #N/A |
| 4 | S-03 | 9 | 9 |  | Ratings, with fallback | No repeat |
| 5 | S-04 | 11 | 6 |  |  |  |
| 6 | S-05 | 10 | 3 |  |  |  |
| 7 | S-06 | 9 | 8 |  |  |  |
| 8 | S-07 | 8 | 5 |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #N/A | No value appears more than once. Wrap the formula in IFERROR, or check whether the data really has a most common value. |
| Only one mode comes back when there are two | MODE returns the first of tied values. In Excel 2010 and later, MODE.MULT returns all of them. |
| MODE ignores text | It only works on numbers. To find the most common text value, count each value with COUNTIF and look up the largest count. |

## Tips

- MODE is handy for spotting the "usual" order quantity or the most common score before setting defaults.

## Related functions

- [MEDIAN](https://spreadsheetpractice.com/functions/median): MEDIAN returns the middle value once the numbers are sorted.
- [AVERAGE](https://spreadsheetpractice.com/functions/average): AVERAGE adds up the numbers you give it and divides by how many numbers there are.
- [COUNTIF](https://spreadsheetpractice.com/functions/countif): COUNTIF counts the cells in a range that meet one condition: tickets marked "Open", scores of 70 or more, product names containing "lamp".

## Questions

### What is the difference between MODE and MODE.SNGL?

None in the result. MODE.SNGL is the newer name introduced in Excel 2010; MODE remains for compatibility.

### Can MODE find the most common word?

No. MODE only works with numbers. Use COUNTIF to count each word and pick the highest count.

## Practice

A graded MODE exercise ("Most common order quantity") is on [the MODE page](https://spreadsheetpractice.com/functions/mode). It is checked instantly, then re-checked on changed data.

---

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