Formulas > =MODE()

How To Use MODE() Function in Google Sheets


Returns the most commonly occurring value in a dataset.

Common questions about the MODE formula:

1. What is the purpose of the MODE formula?
2. What data types is the MODE formula compatible with?
3. What is the syntax of the MODE formula?

How can the MODE formula be used appropriately?

The MODE formula is used to return the most frequently occurring value from a range or array of numerical values. This formula is particularly helpful in summarizing large data sets with multiple distinct values. When using the MODE formula, it is important to ensure that the range you are referencing is free from any duplicate values; if it is not, the resulting mode value may not reflect the true most common value.

How can the MODE formula be commonly mistyped?

Users may mistakenly use the AVERAGE formula in place of the MODE formula. Additionally, users may forget to include the array argument for the formula, leading to a #N/A error.

What are some common ways the MODE formula is used inappropriately?

Some users may mistakenly use the MODE formula to calculate the median, which is returned by the MEDIAN formula. Additionally, using the MODE formula on a range of text values will return an incorrect result, as the formula is only intended for numerical value ranges.

What are some common pitfalls when using the MODE formula?

The most common pitfall when using the MODE formula is that the resulting value may be incorrect or inaccurate if the range or array contains duplicate values. Additionally, if the array contains no unique values, the MODE formula will return a #N/A error.

What are common mistakes when using the MODE Formula?

Common mistakes when using the MODE Formula include using the wrong formula for the desired goal (referring to the misuse of the AVERAGE or MEDIAN formulas in place of the MODE formula), failing to include the array argument for the formula, and attempting to use the formula on a range of text values.

What are common misconceptions people might have with the MODE Formula?

Some users may mistakenly think that the MODE formula will return the median value of a range instead of the most frequently occurring value. Additionally, some users may incorrectly believe that the MODE formula is capable of calculating the mode for a range of text values.

How To Actually Use MODE() in Sheets

MODE(value1, [value2, ...])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the MODE() formula:

Average, Median, & Mode

Discover the concepts: average, median, and mode. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a MODE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.