FREQUENCY function

description:

Get the frequency of values in a data set.

 

syntax:

=FREQUENCY( data_arraybins_array )

 

required arguments:

data_array An array of values for which you want to get frequencies.
bins_array An array of intervals (“bins”) for grouping values.