MODE

Formulas / MODE
Calculate the most frequently occurring number in a set of numbers.
=MODE(number1, [number2], …)
  • number1 - required argument that is the number to calculate the mode of
  • number2 - [OPTIONAL] additional argument that can be an array or reference

Examples

  • =MODE(1,2,4,4,5,5,5,6)

    The MODE function is a statistical function in Sourcetable used to find the most frequently occurring value in a set of data. For example, this will return 5 because 5 appears more frequently than any other value in the set.

  • =MODE(7,8,9,7,9)

    The MODE function can also be used to find the most frequently occurring value when there are two or more values that appear the same number of times. For example, this will return 7 because 7 and 9 both appear twice in the set, but 7 appears first in the list.

  • =MODE(7,9,6,5,3,1,0)

    If the set of numbers contains no values that appear more than once, the MODE function will return an error. For example, this will return an error (#N/A) because none of the values in the set appear more than once.

  • =MODE(B5:J5)

    The MODE function can also be used with a range of cells. For example, this will return the most frequently occurring value in the range B5:J5.

Summary

The MODE function is a useful tool for analyzing data sets. It calculates the most frequently occurring value in a list of numbers and returns the lowest of those values if multiple occur.

  • The MODE function can accept up to 255 separate arguments of numbers, strings, arrays or references, and will ignore empty cells, text values, and logical values.

Frequently Asked Questions

What is the MODE Function?
The MODE function is a statistical function that returns the most frequently occurring value in an array or range of data.
Has the MODE function been replaced?
Yes, the MODE function has been replaced with new functions that may provide improved accuracy. New functions include:
  • MODE.MULT
  • MODE.SNGL
What does the MODE function ignore?
The MODE function ignores text, logical values, and empty cells.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.