MODE

Returns the most commonly occurring value in a dataset.

Sample Usage

MODE(A2:A100,B2:B100,4,26)

MODE(1,2,3,4,5,C6:C20)

Syntax

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

  • value1 - The first value or range to consider when calculating mode.

  • value2, ... - [ OPTIONAL ] - Additional values or ranges to consider when calculating mode.

Notes

  • Although MODE is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

See Also

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.

COUNTIF: Returns a conditional count across a range.

COUNTBLANK: Returns the number of empty cells in a given range.

COUNTA:

Returns the number of values in a dataset.

 

COUNT:

Returns the number of numeric values in a dataset.

 

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
17507991192390372030
true
Search Help Center
true
true
true
true
true
35
false
false