Functions
FREQUENCY
Calculates the frequency distribution of values
Try it
When to use it
When should I use FREQUENCY?
Use FREQUENCY to calculate how many values fall within each bin interval of a distribution, useful for building histograms and analyzing data spread.
Used in
Syntax
FREQUENCY(data, bins)Examples
=FREQUENCY({1,2,3,4,5},{2,4}) // => 2
=FREQUENCY({1,2,3,4,5},{3}) // => 3
=FREQUENCY({10,20,30,40,50},{25,45}) // => 2