Table of Contents
The COUNTIFS function in Google Sheets is a powerful tool that allows users to count cells that meet multiple criteria. This function allows for the selection of specific criteria, such as text, numbers, or dates, and then counts the cells that meet all of the selected criteria. This makes it an efficient and effective method for analyzing data and obtaining accurate counts. By using the COUNTIFS function, users can easily identify and track specific data points within a larger dataset, making it a valuable tool for data analysis and organization.
COUNTIFS
Returns the count of rows depending on multiple criteria
Sample Usage
COUNTIFS(table_name!fruits, “Apple”, table_name!inventory, “<30”)
Syntax
COUNTIFS(criteria_column1, criterion1, criteria_column2, criterion2)
criteria_column1– The data column to check against `criterion1`.criterion1– The pattern or test to apply to `criteria_column1`.criteria_column2– Additional data column to check.criterion2– Additional criteria to check.
Sample Usage
COUNTIFS(A1:A10, ">20", B1:B10, "<30")
COUNTIFS(A7:A24, ">6", B7:B24, "<"&DATE(1969,7,20))
COUNTIFS(B8:B27, ">" & B12, C8:C27, "<" & C13, D8:D27, “<>10”)
COUNTIFS(C1:C100, "Yes")
Syntax
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
criteria_range1– The range to check againstcriterion1.criterion1– The pattern or test to apply tocriteria_range1.criteria_range2, criterion2...– [ OPTIONAL ] – Additional ranges and criteria to check; repeatable.
Notes
- Any additional ranges must contain the same number of rows and columns as
criteria_range1.
See Also
COUNTIF: Returns a conditional count across a range.
COUNT:
Returns the number of numeric values in a dataset.
SUMIFS: Returns the sum of a range depending on multiple criteria.
AVERAGEIFS: Returns the average of a range depending on multiple criteria.
IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
Cite this article
stats writer (2024). How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-countifs-function-in-google-sheets-to-count-cells-that-meet-multiple-criteria/
stats writer. "How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-countifs-function-in-google-sheets-to-count-cells-that-meet-multiple-criteria/.
stats writer. "How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-countifs-function-in-google-sheets-to-count-cells-that-meet-multiple-criteria/.
stats writer (2024) 'How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-countifs-function-in-google-sheets-to-count-cells-that-meet-multiple-criteria/.
[1] stats writer, "How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the COUNTIFS function in Google Sheets to count cells that meet multiple criteria?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.