In this example, we’re looking at the number of scores based on the Bins values. Select four cells and type the formula =FREQUENCY(A2:A10,B2:B4), then hit CTRL+Shift+Enter to convert it to an array formula. As you can see, all of the cells have the same cell address and a curly bracket to indicate that they are part of an array formula.

The findings may be seen in the four cells from A13 to A16. This function first determines how many scores are equal to or lower than the first bin value of 55, and then determines how many scores are between 56 and 62 (above the first bin value and up to the second bin value).

Third, it examines how many scores occur between 63 and 75 (above the second bin value and up to the third bin value), and last, it examines how many scores occur over 75.