Skip to main content


Definition/Description of Formula:

Returns the most commonly occurring value in a dataset.


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.

See Also: 

 COUNTIF: Returns a conditional count across a range.

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


To use the MODE Formula, simply begin with your edited Excellentable:  

Then begin typing the MODE formula in the area you would like to display the outcome:



User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.