Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
FREQUENCY
FREQUENCY distributes a dataset into intervals defined by a bins array and returns how many data points fall into each interval. It is an array function commonly used to build histograms and analyze distributions of test scores, ages, or any numeric measurement.
Excel
=FREQUENCY(A2:A5,{60;75;90})Google Sheets
=FREQUENCY(A2:A5,{60;75;90})Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1List your numeric data values in one range and your bin upper boundaries in a separate range or array.
- 2Select a vertical output range with one more row than the number of bins to capture values above the last bin.
- 3Enter =FREQUENCY(data_range, bins_array) as an array formula (Ctrl+Shift+Enter in older Excel) to populate all frequency counts.
Need a version for your data?
Try: “Count how many test scores fall in the ranges 0-60, 61-75, 76-90, and above 90”