Google Sheets | FREQUENCY | Function | Count | Values | Example | Spreadsheet | Tutorial

With the Google Sheets FREQUENCY function, get the frequency distribution of data in one-column, based on the specified set of classes. For example, using FREQUENCY function, you can get the count of scores on a test in the range of each value in the set.
-------------------------------------
How to Use QUERY in Google Sheets?
QUERY helps, among others, to extract specific or all data from a range:
• Google Sheets | QUERY ...
-------------------------------------
How to Use QUERY with WHERE clause and MATCHES operator in Google Sheets?
MATCHES operator assists to conduct an exact or a wildcard search:
• Google Sheets | QUERY ...
-------------------------------------
How to Use QUERY with WHERE clause and starts with or ends with operators in Google Sheets?
Use where clause and starts with, ends with or both the operators to get data based on one or more conditions:
• Google Sheets | QUERY ...
-------------------------------------
How to Use QUERY with WHERE clause in Google Sheets?
To conditionally extract data, use the QUERY function with its WHERE CLAUSE:
• Google Sheets | QUERY ...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKU...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets ...
-------------------------------------
How to Use IFS in Google Sheets?
IFS allow multiple logical expressions:
• Google Sheets IFS | Te...
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tut...
-------------------------------------
How to Use IF with AND in Google Sheets?
Use IF with AND to Use Multiple Logical Expressions in IF:
• Google Sheets | IF | A...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot ...
-------------------------------------
Which one to Use? A Pivot Table, or COUNTBLANK Function, to Count Blank Cells in Google Sheets:
Gives steps to use a pivot table or COUNTBLANK to count blank cells:
• Google Sheets | Pivot ...
-------------------------------------
Let's look at the syntax of the FREQUENCY function formula:
=FREQUENCY(data, classes)
data is a one-column set of values.
classes is a range with a set of reference values.
Here is an example of the FREQUENCY function formula:
Assume that each cell in the range B3 to B9 has a donation amount. The reference values are in cells D3 to D7.
Let's substitute the above values for the data and classes argument:
=FREQUENCY(B3:B9, D3:D7)
Assume that the function returns the following values: 0,1,3,0,1,2.
The values returned are one more than the values in the classes range. The
last value returned, 2, in this case, indicates that there are two values in the
data range that are greater than the highest value in the classes range.
Take a look at this video tutorial, which gives the steps to use the FREQUENCY function, to get the frequency distribution of values, with examples.