## How to use the MODE function

*Article updated on April 19, 2018*

The MODE function calculates the most frequent number in a cell range.

Number 4 exists 3 times on picture above and number 2 exists only 2 times. Number 4 is the most frequent number in B3:B10.

### Excel Function Syntax

MODE(*number1*,[*number2*],...)

### Arguments

number1 |
Required. A cell range you want to calculate the most frequent number. |

[number2] |
Optional. Up to 254 additional arguments. |

### Recommended functions

How to use the AVERAGE function

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]

How to use the MEDIAN function

The MEDIAN function calculates the median based on a group of numbers. The median is the middle number of a […]

### Functions in 'Compatibility'

The MODE function function is one of many functions in the 'Compatibility' category.

The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution. Formula in cell B6: =CONFIDENCE(B3, […]

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance. Excel Function Syntax FLOOR(number, significance) Arguments […]

The MODE function calculates the most frequent number in a cell range. Number 4 exists 3 times on picture above […]

The RANK function calculates the rank of a specific number compared to a list of numbers. Formula in cell C3: […]

The STDEV function calculates the standard deviation of a group of values. Standard deviation shows how much the values differ from the […]