## 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.