How to Use the FREQUENCY Function in Excel - Array Formula Example

How to Use the FREQUENCY Function in Excel - Array Formula Example

In this tutorial, we’ll show you how to use the Excel Frequency function.

The FREQUENCY function returns a frequency distribution as a vertical array.

Create a vertical range of cells containing the upper bandings with which you wish to group your data (for example 0-10, 11-20 and so on 91-100)

Select the output range.
The FREQUENCY formula returns an array; we’ll use an array formula.

Type this formula: FREQUENCY.

Select the data array.

Select the range which contains intervals.

Use the keystrokes of Control + Shift + Enter’

The formula appears with curly brackets around it.

#MsExcel #Formula #Array #Frequency

[toxcjck]

Thanks! Helped me out a lot as I keep on getting confused on how to use the frequency function.

[emca]

I don't understand why my frequency distribution always ends up in a 0, did i perhaps did something wrong?

[mmnn-gsbg]

Wonderful illustration, thanks a lot.

[alokkumar]

But the results are incorrect in your sheet.. I can clearly see there are 4 entries that is less than 10 but frequency function shows 3

[ashnaanil]

Hello, I have a question, when I try this same method, I keep on getting 0 instead of any value for frequency, how can I correct it