Calculates how often values occur within a range of values and returns a vertical array of numbers.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
FREQUENCY(data_array, bins_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})Ergebnis: {2; 2}
Counts how many values are less than or equal to 25 (10, 20) and how many are greater than 25 (30, 40).
The extra row contains the count of all values in the data_array that are greater than the largest value in the bins_array.