MODE.MULT
TheMODE.MULT
formula is a statistical function that returns an array of the most frequently occurring values in a range of data. It can handle multiple modes and will return a mode for each unique value in the input range. This formula is most commonly used to identify the most common values in a dataset.
 How to use
MODE.MULT
formula?  Examples of using
MODE.MULT
formula MODE.MULT
formula not working? Similar formulas to
MODE.MULT
Usage
Use the MODE.MULT
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value1 (required):
The first value or range of values to evaluate for modes.  value2 (optional):
Additional values or ranges of values to evaluate for modes.
Examples
Here are a few example use cases that explain how to use theMODE.MULT
formula in Google Sheets.
Finding the most common values in a dataset
By using MODE.MULT
, you can quickly identify the most frequently occurring values in a dataset, which can be helpful for identifying trends and outliers.
Handling multiple modes
With MODE.MULT
, you can easily handle datasets with multiple modes, as it will return a mode for each unique value in the input range.
Comparing data sets
By using MODE.MULT
on multiple datasets, you can easily compare the most common values between them, which can be helpful for identifying similarities and differences.
Common Mistakes
MODE.MULT
not working? Here are some common mistakes people make when using the MODE.MULT
Google Sheets Formula:
Providing nonnumerical values
If any of the provided values are not numerical, the formula will return an error. Doublecheck that all input values are numerical.
Providing only one value
The formula requires at least two input values to calculate the mode. Providing only one value will result in an error.
Providing a range of cells as input
The formula only accepts individual values as input. If you need to calculate the mode for a range of values, you will need to use an array formula.
Providing empty cells as input
Empty cells will be treated as a zero value and may skew the results. Make sure to exclude any empty cells from the input range.
Having multiple modes
If there are multiple values with the same highest frequency, the formula will only return one of them. Consider using other methods to identify all modes in the data.
Related Formulas
The following functions are similar to MODE.MULT
or are often used with it in a formula:

MODE
The MODE formula in Google Sheets returns the most frequently occurring value in a dataset. It is commonly used in statistical analysis to identify the value that occurs most frequently in a set of data. The formula requires at least one input value, but can accept multiple values to include in the analysis.

MEDIAN
The
MEDIAN
function returns the median (middle) value of a set of numbers. It is commonly used to find the middle value in a range of data points. If the number of data points is even, it returns the average of the two middle values. This function can be useful in statistical analysis and data visualization. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

COUNTIF
The
COUNTIF
formula counts the number of cells within a specified range that meet a certain criterion. This formula is commonly used to count cells that meet a specific condition or criteria. 
SUMIF
The
SUMIF
formula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis.
Learn More
You can learn more about the MODE.MULT
Google Sheets function on Google Support.