Skip to Content

FREQUENCY

Returns a frequency distribution as a vertical array

Syntax

FREQUENCY(data_array, bins_array)

Parameters

  • data_array: Required. An array of or reference to a set of values for which you want to count frequencies
  • bins_array: Required. An array of or reference to intervals into which you want to group the values in data_array

Example

=FREQUENCY(A1:A10, B1:B3)
Returns: ArraySince: Excel 2003