MODE

The MODE function in Google Sheets returns the most commonly occurring value in a dataset.

Parameters

• value1: The first value or range to consider.
• value2, ...: [Optional] Additional values or ranges to consider.

Step-by-Step Tutorial

1. Using MODE with individual values:

   • Example: =MODE(1, 2, 2, 3, 3, 3)
   • Result: 3

2. Using MODE with a range of cells:

   • Example: If A1:A5 has the values 1, 2, 2, 3, 3, 3, then =MODE(A1:A5) will return 3.

Working with a Single Value, a List, and a Range

MODE accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely. It returns the value that occurs most frequently in the dataset.

• Single value: =MODE(A1) — with only one value and nothing to repeat, this returns a #N/A error, since there's no mode.
• List of values: =MODE(A1, A2, A3, A4) — if A1 through A4 are 1, 2, 2, 3, this returns 2, the value that appears most often.
• Range: =MODE(A1:A10) — returns the most common value across every cell in the range.
• Mixed: =MODE(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Use Cases and Scenarios

1. Survey Responses: Determine the most common response in a survey.
2. Stock Analysis: Find the most frequently occurring stock price.
3. Test Scores: Identify the most common test score in a class.

Related Functions

• MEDIAN: Find the middle value in a set.
• AVERAGE: Calculate the average of a range of values.

Related Articles

• Top 4 Statistical Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know