How to Use the FREQUENCY Function in Excel

This guide explains how to use FREQUENCY Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function performs the calculation and returns the frequency of occurrences of values within a certain range and returns a vertical array of numbers.

Syntax: FREQUENCY (data_array, bins_array)

Inside:

- data_array: Array or reference to a set of values to calculate its frequency.

- bins_array: Array or reference to the values to be calculated.

Attention:

- The function ignores values of blank cells and text.

- The number of components in data_array returns more than the number of components in bins_array.

- Array formulas must be entered as an array formula

For example:

Find the number of items with a quantity less than 35 or 40 in the data table below:

- The number of items is less than 25. In the cell to calculate enter the formula : = FREQUENCY (D6: D10, E6: E8)

- Press Enter -> Number of items less than 25 is:

- Similarly copy for cases where the number is less than or equal to 40 -> enter the formula: = FREQUENCY (D6: D10, E7: E9) -> press Enter to get the results:

Above are instructions and some specific examples when using the FREQUENCY function in Excel.

Good luck!