Formulas > =FREQUENCY()

How To Use FREQUENCY() Function in Google Sheets


Calculates the frequency distribution of a one-column array into specified classes.

Common questions about the FREQUENCY formula in Google Sheets include:
What does the FREQUENCY formula do?
How do I use the FREQUENCY formula in Google Sheets?
What are the arguments of the FREQUENCY formula?
Can the FREQUENCY formula handle non-numeric data?
How does the FREQUENCY formula handle empty cells?
Can the FREQUENCY formula work with ranges from multiple columns or sheets?
Are there any limitations or restrictions when using the FREQUENCY formula?

The FREQUENCY formula in Google Sheets is used to calculate the frequency distribution of values in a dataset. It counts the occurrences of values within a specified range and returns an array of frequencies. This formula is commonly used in data analysis and statistical calculations.

To use the FREQUENCY formula appropriately, follow these steps:

Select a range where you want to display the frequency distribution.
Enter the FREQUENCY formula, specifying the data range and the bins range as arguments.
Press Enter to calculate the frequencies.

The FREQUENCY formula can be mistyped in several ways. Here are a few common mistakes:
Misspelling the formula as "FREQUENCIES" or "FREQUENSY."
Omitting the required arguments or using incorrect argument syntax.
Mixing up the order of the data range and bins range arguments.
Using invalid or incompatible data types in the formula.

The FREQUENCY formula can be used inappropriately in a few common ways:
Applying the formula to non-numeric data or ranges containing non-numeric values.
Using the formula with incorrect or overlapping bins ranges.
Using the formula with data ranges that include empty cells or cells with text.

When using the FREQUENCY formula, there are some common pitfalls to watch out for:
Incorrectly setting up the bins range, which can lead to incorrect frequency results.
Failing to account for outliers or extreme values that may affect the distribution.
Not properly updating the formula when modifying the dataset, which can result in outdated frequencies.

Common mistakes when using the FREQUENCY formula include:
Forgetting to enter the formula as an array formula by pressing Ctrl+Shift+Enter instead of just Enter.
Incorrectly referencing ranges that are not the same size, leading to inaccurate results.
Neglecting to expand the output range to accommodate the resulting array of frequencies.

Common misconceptions people might have about the FREQUENCY formula:
Assuming that the formula automatically sorts the output frequencies in ascending or descending order.
Believing that the formula can handle complex statistical calculations beyond basic frequency distributions.
Expecting the formula to automatically update when new data is added, removed, or modified.

It's important to thoroughly understand the FREQUENCY formula and its usage to avoid these common pitfalls and misconceptions.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There are no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use FREQUENCY() in Sheets

FREQUENCY(data, classes)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the FREQUENCY() formula:

Generate a FREQUENCY() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.