Excel Function
COUNTIFS Function in Excel
Learn how to use the COUNTIFS function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)Arguments
What each part of the formula does.
criteria_range1RequiredThe first range to test.
criteria1RequiredThe first condition to count.
criteria_range2+OptionalAdditional range and criteria pairs.
Examples
Count active customers in one region
=COUNTIFS(B:B, "West", C:C, "Active")Counts rows where region is West and status is Active.
Count late tasks for one owner
=COUNTIFS(D:D, "Late", E:E, "Maria")Counts rows where the task is Late and the owner is Maria.
Common mistakes
Check the argument order, data types, and references used in COUNTIFS.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
COUNTIF
Learn how to use the COUNTIF function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
SUMIFS
Learn how to use the SUMIFS function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
AVERAGEIFS
Learn how to use the AVERAGEIFS function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.