Statistical
FREQUENCY function: group numeric values into histogram bins
Count how many observations fall into each upper-bound interval—plus the overflow bin above the highest threshold—using FREQUENCY.
Inclusive upper bounds and the extra overflow bin
FREQUENCY(data_array, bins_array) counts how many numeric values fall into each interval defined by bins_array (inclusive of each bin upper bound) and appends one extra overflow element for values strictly above the highest bin.
Because every numeric observation lands in exactly one bin (including the overflow bin), SUM(FREQUENCY(A2:A7, C2:C4)) always equals COUNT(A2:A7).
=SUM(FREQUENCY(A2:A7, C2:C4))Try the example
Use the original values or change them to test your understanding.