Google Sheets | FREQUENCY | COUNTIFS | Function | Example | Comparison | Spreadsheet | Tutorial

Google Sheets FREQUENCY or COUNTIFS function can return the count of values that meet one or more criteria. The question, then, is which of these two functions to use? While FREQUENCY is easy to use, COUNTIFS is versatile.
For more info on FREQUENCY or COUNTIFS, please refer to their respective tutorials, whose links are given below.
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
• Google Sheets | FREQUE...
-------------------------------------
How to Use COUNTIFS in Google Sheets?
Count values that fulfill one or more criteria:
• How to use COUNTIFS in...
-------------------------------------
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 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 ...
-------------------------------------
The syntax of the FREQUENCY function formula is:
=FREQUENCY(data, classes)
data is a range of values in one column.
classes are the distribution intervals.
An example of the FREQUENCY function formula:
=FREQUENCY(C2:C11, G2:G6)
Let's assume that the function returns the following values: 5,7,3,0,9,3.
The numbers are count of values less than or equal to, or greater than or equal to and less than or equal to, a distribution interval value. FREQUENCY returns one value more than the distribution intervals. That value is 3 in this case. It is the count of values greater than the maximum distribution interval value.
The syntax of the COUNTIFS function formula is:
=COUNTIFS(criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])
criteria_range1 is the first range to which criterion1 will be applied.
criterion1 is the first condition that values in criteria_range1 should meet to be counted.
Here is an example of COUNTIFS function:
=COUNTIFS(A2:A6, "100" )
The function returns count of values in the range A2 to A6 that is equal to 100.
Review this video tutorial, which gives the steps to use the FREQUENCY and COUNTIFS function, to get the count of values, with examples.