Syntax. FREQUENCY(data_array,bins_array)

Definition. This function returns a frequency distribution as single-column matrix. For example, use FREQUENCY() to count the sales in a certain area. Because FREQUENCY() returns an array of values, it must be entered as an array formula.


  • data_array (required). An array of or a reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY() returns an array of zeros.

  • bins_array (required). An array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY() returns the number of elements in data_array.

Background. To reduce the quantitative data, the existing data are ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.