What it does
COUNTIFS counts rows that match multiple conditions.
Syntax or pattern
=COUNTIFS(criteria_range1, criteria1, ...)✅
5 practical examples
1
Count by region and status
Count open East orders.
=COUNTIFS(Orders[Region],"East",Orders[Status],"Open")Each condition is applied to the same rows.
2
Count within date range
Count orders between two dates.
=COUNTIFS(Orders[Date],">="&F1,Orders[Date],"<="&G1)Use two criteria on the same date column.
3
Count excluding a status
Count rows not cancelled.
=COUNTIFS(Orders[Status],"<>Cancelled")<> means not equal.
4
Count by dropdown selections
Use cells as criteria.
=COUNTIFS(Sales[Region],H2,Sales[Product],H3)Good for interactive reports.
5
Count blank owners by status
Find open tasks with no owner.
=COUNTIFS(Tasks[Status],"Open",Tasks[Owner],"")A practical data cleanup check.
Common mistakes to avoid
- Selecting ranges with different sizes.
- Using text values where numbers are required.
- Forgetting how blanks and hidden rows are treated.
Related Excel examples
FAQ
Can this formula use Excel Tables?
Yes. Structured references often make summary formulas easier to read.