Microsoft Excel's Frequency function simplifies this process. This function displays the number of data points falling within given ranges and sets the stage for charting these frequencies.

This relative reference can be included in almost any formula to reference single cells, such as "=A1+1" or "=A1+A2+A3." Place a colon between two relative references to include all cells between ...

This newish function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx file .