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