Skip to main content



Calculates the frequency distribution of a one-column array into specified classes.

Sample Usage


FREQUENCY(data, classes)

  • data - The array or range containing the values to be counted.

  • classes - The array or range containing the set of classes.

    • classes should be sorted for clarity, but FREQUENCY will sort the values specified internally if they are not and return correct results.


  • The output of FREQUENCY will be a vertical range of size one greater than classes as the final value is the number of elements in data greater than any of the class boundaries.

In order to use the FREQUENCY formula, start with your edited Excellentable:





User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.