IntermediateCounting
Syntax
=COUNTIFS(range1, criteria1, [range2, criteria2], ...)| Argument | What it means |
|---|---|
range1, criteria1 | The first range and its condition. |
range2, criteria2 | Optional. More pairs. A row is counted only if all conditions are true. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Office supplies sales (fictional)
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Region | Date |
| 2 | Pen | 10 | 1.5 | North | 2025-01-15 |
| 3 | Notebook | 5 | 12 | South | 2025-02-03 |
| 4 | Pen | 20 | 1.5 | South | 2025-02-28 |
| 5 | Stapler | 2 | 40 | North | 2025-03-10 |
| 6 | Folder | 15 | 3.25 | East | 2025-03-22 |
| 7 | Notebook | 8 | 12 | East | 2025-04-05 |
| 8 | Pen | 12 | 1.5 | North | 2025-04-18 |
| 9 | Marker | 30 | 2 | South | 2025-05-02 |
=COUNTIFS(A2:A9,"Pen",D2:D9,"South")Pen orders in the South
=COUNTIFS(B2:B9,">=10",D2:D9,"North")Orders of 10 or more in the North
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use COUNTIFS at work
- HR
Sales team members rated 4 or higher.
Data: Team list (fictional)=COUNTIFS(B2:B8,"Sales",E2:E8,">=4") - Finance and accounting
Invoices over 1000 for one customer.
Data: Customer invoices (fictional)=COUNTIFS(B2:B6,"Harbour Cafe",C2:C6,">1000")
Common mistakes and tips
- All the ranges must be the same size.
- Each condition needs its own range, even if it is the same range twice (for example, a date between two limits).
Works in
All versions of Excel, and Google Sheets.
Lessons that use it
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.