Understanding the MODE function in Google Sheets

  1. Find the most common number in your spreadsheet
  2. Find the most common value using the MODE function
  3. Syntax and arguments of the MODE . function
  4. How to use the MODE function in Google Sheets
  5. Find multiple modes

Find the most common number in your spreadsheet

Google Sheets is an easy-to-use spreadsheet that makes your documents available anywhere you have internet access. Since it is not tied to a single machine, it can be accessed from anywhere and from any type of device. If you’re new to Google Sheets, there are a few features you need to learn to get started. Here we will look at the MODE function, which finds the most common value in a series of numbers.

Find the most common value using the MODE function

To call a number:


mode number 1, as it appears twice in the list and all other numbers appear only once.

If two or more numbers appear the same number of times in a list, they combine to form a mode.

To call a number:


both numbers 1 and 2 are modes as they both appear twice in the list while number 3 only appears once. In the second example, the sequence of numbers is “bimodal”.

Use the MODE function to find the dialing mode when using Google Sheets.

Syntax and arguments of the MODE . function

Function syntax refers to the layout of the function and includes the function name, parentheses, comma separators, and arguments.

The syntax for the MODE function is: = MODE(number_1, number_2, … number_30)

  • number_1 – (mandatory) data included in mode calculation

  • number_2: number_30 – (optional) additional data values ​​included in calculation mode. The maximum number of entries allowed is 30.

Arguments may include:

  • list of songs

  • cell references for organizing data on a sheet

  • cell reference range

  • named range

How to use the MODE function in Google Sheets

Open a new blank Google Sheets document and follow the steps below to learn how to use the MODE function.

The MODE function only works with numerical data.

  1. Enter your data into the Google Spreadsheet and then click the cell where you want to insert the MODE function.

  2. Enter “ =MODE(“) to start the formula.

  3. Select the cells containing the data you want to analyze.

    You can select a range of cells by clicking each one or by clicking and dragging. To use the entire column, click the column header or type “[метка столбца]† [метка столбца]†

  4. After you finish highlighting the cells, close the parentheses and then click Enter † The mode of the selected data replaces the formula in the cell.

    If no value occurs more than once in the selected range of data, a #N/A error appears in the function cell.

  5. The formula is updated if you change the original dataset and change the mode.

Find multiple modes

The data you are analyzing may be polymodal: plurals are ‘linked’ for the most common cases. Using the MODE function returns only one of these numbers: the number closest to the top of the worksheet. Google Sheets has a different formula that selects all modes. Here’s how to use it.

  1. Instead of “= MODE(,” enter “ = MODE.MULT(“) to start the formula.

    You can also change the formula by clicking and editing a cell in the input bar at the top of the screen.

  2. Select the cells as usual and then close the parentheses to complete the function.

  3. If you click now Enter all the modes in the set will appear on a separate line, starting with the one in which you entered the formula.

  4. Google Sheets doesn’t allow you to delete entries in cells that don’t contain a formula. But if you clear a cell with a function, all other modes will be removed.

Leave a Reply

Your email address will not be published. Required fields are marked *