Back to All Formulas
Math & StatsLevel 3: Yellow (Core Formulas & Logic)Difficulty: Intermediate
How to Use COUNTIFS in Excel
Counts the number of rows that satisfy multiple simultaneous criteria.
Formula Syntax
=COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, )
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| criteria_range1 | Required | The range of cells to test. |
| criteria1 | Required | The condition to match (e.g. '>100' or 'Active'). |
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Lead Status | Deal Value | Owner |
|---|---|---|
| Won | 50000 | Vikas |
| Lost | 25000 | Vikas |
| Won | 85000 | Anita |
| Won | 30000 | Vikas |
Applied Formula:Result: 2
=COUNTIFS(A2:A5, "Won", C2:C5, "Vikas")
How it works: Counts how many deals were 'Won' specifically by 'Vikas'.
Common Errors & How to Fix Them
Incorrect Count (0)
Why it happens: Comparison operator syntax error, such as forgetting quotes around > or <.
Fix: Wrap operators in double quotes, e.g. ">=50000" or ">"&D1.
Ready to Master Excel?
Explore 7 LevelsMaster COUNTIFS in Level 3
Learn COUNTIFS alongside 500+ formulas, hands-on practice workbooks, and verifiable certificates.