Syntax
MODE(value1, [value2, ...])
| Parameter | Description |
|---|---|
| value1 | Parameter of the MODE function. |
| [value2 | (Optional.) Parameter of the MODE function. |
| ...] | Parameter of the MODE function. |
Examples
Most common shoe size
Formula
=MODE(B2:B200)
Returns the shoe size that appears most often in 199 sales records. If size 10 appears 34 times and no other size appears more, returns 10.
Most popular rating
Formula
=MODE(D2:D1000)
Returns the most frequently given star rating (1-5) from customer reviews.
Mode of specific values
Formula
=MODE(3, 7, 3, 2, 7, 7, 5)
Returns 7 because it appears 3 times, more than any other value.
Common Errors
#N/A
Returned when no value appears more than once. MODE requires at least one duplicate value to return a result.
#VALUE!
Occurs if all arguments are non-numeric. MODE only works with numbers.
Tips
Only returns one mode
If your data is multimodal (multiple values tied for most frequent), MODE returns only the lowest one. Use MODE.MULT as an array formula to get all modes.
Text values are ignored
MODE skips text cells in a range. If you need the most common text value, use INDEX/MATCH with COUNTIF instead.
Useful for discrete data
MODE works best with discrete values (integers, ratings, categories coded as numbers). For continuous data with many decimal places, every value may be unique, resulting in #N/A.
Try MODE in Viztab
Import your data and use MODE with 370+ other formulas. No signup required.
Open Viztab