FREQUENCY

Using the Excel FREQUENCY Function

Summary

The Excel FREQUENCY function counts the number of times a value occurs within a range of values, and then returns a vertical array. Since FREQUENCY returns an array, it must be entered as an array formula.

Syntax

=FREQUENCY (data_array, bins_array)

Syntax Breakdown

Data Array
Required. Array or reference to a set of values for which you want to count the frequency. If the data_array argument does not contain any values, the function returns an array of zeros (0).

Bins Array
Required. Array or reference to intervals into which you want to group the values in the data_array argument. If the bins_array argument does not contain any values, the function returns the number of elements in data_array.


Usage Notes

FREQUENCY returns a frequency distribution table. This is a summary that shows the frequency of each value in a given range. The function is useful if you need to create a frequency distribution. FREQUENCY will ignore blank cells and text.

It is important to enter FREQUENCY as an array formula using Ctrl + Shift + Enter, as opposed to simply enter.

FREQUENCY will return an array that has one more element than the bins_array argument. This is intentional, and is used to return the count of any values above the highest interval.