What is the syntax for MODE.MULT in Excel?

The syntax for MODE.MULT is: =MODE.MULT(number1, [number2], ...)

How do I use the MODE.MULT function?

To use MODE.MULT, type =MODE.MULT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does MODE.MULT work with?

MODE.MULT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is MODE.MULT not working in my Excel?

Common issues with MODE.MULT include #N/A if no duplicates. Start by checking the syntax =MODE.MULT(number1, [number2], ...), then verify each referenced cell or range.

Statistical

MODE.MULT Function in Excel

Returns a vertical array of the most frequently occurring values in a data set.

Syntax

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

Arguments

number1 (required): First number or range
number2 (optional): Additional numbers

Examples

=MODE.MULT(A1:A100) - All modes - Result: Array of modes

MODE.MULT for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#N/A if no duplicates

Use cases

Multimodal data
Statistical analysis
Data distribution

Frequently asked questions

What is the MODE.MULT function in Excel? MODE.MULT returns a vertical array of the most frequently occurring values in a data set. The syntax is =MODE.MULT(number1, [number2], ...). Typical use cases include multimodal data, statistical analysis, data distribution.
How do I use the MODE.MULT function? To use MODE.MULT, type =MODE.MULT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does MODE.MULT work with? MODE.MULT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is MODE.MULT not working in my Excel? Common issues with MODE.MULT include #N/A if no duplicates. Start by checking the syntax =MODE.MULT(number1, [number2], ...), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.