The FREQUENCY function compares a range of data against various intervals. It gives the number of items in the range of data which falls under the interval. Note: The function is enclosed in { } brackets as it is entered in the cells as an array.
Formula:
=FREQUENCY (Range of Data, List of Intervals)
Video Tutorial:
Let us find the frequency of values falling in a particular interval, using the FREQUENCY function, with the help of the below video