Which jobs use Microsoft Excel frequently

FREQUENCY (function)

The FREQUENCY function calculates the number of times values ​​occur within a range of values ​​and then returns a vertical matrix of numbers. For example, use FREQUENCY to count exam results within specific result ranges. Since FREQUENCY returns an array, the formula must be entered as an array formula.

FREQUENCY (dates; classes)

The FREQUENCY function syntax has the following arguments:

  • data_array Required. Corresponds to a matrix of or a reference to a set of values ​​whose frequencies you want to count. If "data" does not contain any values ​​(numbers), FREQUENCY returns a matrix with zeros.

  • bins_array Required. The interval limits entered as a matrix or reference to a cell range, according to which you want to classify the values ​​contained in "Data". If "Classes" does not contain any values, FREQUENCY returns the number of elements belonging to "Data".

Note: If you have an up-to-date version of Microsoft 365, you can just enter the formula in the top left cell of the output range and then the ENTER Press to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a conventional array formula by first selecting the output range, entering the formula in the cell in the top left of the output range, and then using CTRL + SHIFT + ENTER is confirmed. Excel automatically inserts curly braces at the beginning and end of the formula. For more information about array formulas, see Array Formula Guidelines and Examples.

  • The result matrix comprises one more element than the "classes" argument specified as a matrix or reference to a range of cells. The extra element in the returned matrix returns the number of values ​​above the highest interval. For example, if you are counting three ranges of values ​​(intervals) entered in three cells, make sure you enter FREQUENCY in four cells for the results. The additional cell returns the number of values ​​in "Matrix" that are greater than the third interval value.

  • FREQUENCY ignores both blank cells and text.


Do you need more help?

You can always ask an expert in the Excel Tech Community, get support from the Answers Community, or suggest a new feature or improvement on Excel User Voice.