The function frequency calculates how many times a value occurs within a range of values and returns the result in a vertical array.
Syntax:
=Frequency(range to evaluate, {ranges})
Range to evaluate. is the array or range of cells containing the values for which you want to count frequencies within the defined ranges.
Ranges. these are the defined ranges into which you want to group the values from the range to evaluate. Only the top of the range is required.