Excel MODE Function

Using the Excel MODE Function


The Excel MODE function returns the most frequent value in a an array or range of data.

The MODE function is now considered a compatibility function in Excel. It is recommended to use either MODE.SNGL or MODE.MULT.


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

Syntax Breakdown

Number 1
Required. First number argument for which you want to find the mode, or most frequently occurring value. Inputs can be an array, number, or reference.

Number 2
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MODE returns the most frequently occurring number in a data set. If a given data set doesn't contain any duplicate numbers, the function returns the #N/A error.

If a number argument is an array or reference, and the array or reference contains text, logical values, or empty cells, they will be ignored. Cells with a zero value will be included.

The function will return an error if arguments include error values or text that cannot be translated into a number.

MODE, along with AVERAGE and MEDIAN, is a measure of central tendency.