Calculates how often values occur within a range of values and returns a vertical array of numbers.
Syntax
FREQUENCY(data_array, bins_array)Arguments
data_arrayrequired
An array of or reference to a set of values for which you want to count frequencies.
bins_arrayrequired
An array of or reference to intervals into which you want to group the values in data_array.
The FREQUENCY function calculates the frequency distribution of data within specified bins. It returns an array that has one more element than the bins_array, representing the count of values above the highest bin.
=FREQUENCY({10,20,30,40}, {25})→{2; 2}Counts how many values are less than or equal to 25 (10, 20) and how many are greater than 25 (30, 40).
Select the output range
Select a vertical range of cells that has one more row than your bins_array.
Enter the formula
Type the formula and press Ctrl+Shift+Enter if using an older version of Excel, or simply Enter in modern Excel.
The extra row contains the count of all values in the data_array that are greater than the largest value in the bins_array.