MODE function in Excel

Syntax

=MODE(number1, [number2], …)

Example

=MODE(A2:A8) returns the most common shoe size.

From the lesson MODE Function.

Common mistakes

• Expecting MODE to work on text (it only looks at numbers).
• Not handling the #N/A you get when nothing repeats.

Related statistical functions

• COUNTCounts cells that contain numbers.
• COUNTACounts cells that are not empty.
• COUNTBLANKCounts empty cells in a range.
• COUNTIFCounts cells that meet one condition.
• COUNTIFSCounts cells that meet several conditions.
• AVERAGEReturns the arithmetic mean.
• AVERAGEIFAverages cells that meet a condition.
• MINReturns the smallest value.