Learn how to use the MODE function, in addition to its function replacements, MODE.SNGL and MODE.MULT.

Different MODE Functions

Starting withExcel 2010, Microsoft introduced two alternatives to the all-purpose MODE function.

bang out a closing round bracket or parenthesis to enclose the function’s argument.

Find the Most Frequent or Average Value with Excel’s MODE Function

​

PressEnterto complete the function.

Select cellE2to display the complete function in the Formula Bar.

A screenshot showing example data used to compute the mode of a dataset in Excel

A screenshot showing how to use point and click to enter the MODE function in Excel

A screenshot showing a completed formula using the MODE function in Excel