FREQUENCY returns the distribution as avertical arrayof numbers that represent a “count per bin”.

The FREQUENCY function always returns an array withone more itemthan bins in thebins_array.

This is by design, to catch any values greater than the largest value in thebins_array.

Excel formula: Count numbers by range

The general pattern for FREQUENCY is:

wheredata_arrayandbins_arrayare typicallyrangeson the worksheet.

Note: the curly braces added by Excel automatically when entered withcontrol + shift + enter.

Horizontal results

The FREQUENCY function always returns a verticalarrayof results.

Excel formula: Count unique numeric values with criteria

For example, =MODE(1,2,4,4,5,5,5,6) returns 5.

Excel formula: Count unique numeric values in a range

Excel formula: Longest winning streak

Excel formula: Count unique text values with criteria

Excel formula: Count consecutive monthly orders

Excel formula: Histogram with FREQUENCY

Excel formula: Count unique text values in a range

Excel MODE function