📎 This article includes 1 downloadable practice file ↓
In this article
COUNTIFS counts rows where every condition is true.
Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)| Argument | What it means |
|---|---|
criteria_range1, criteria1 |
First range and condition. |
Examples
Example 1
=COUNTIFS(B:B, "North", E:E, ">=50000")Big North orders.
Example 2
=COUNTIFS(A:A, ">="&G1, A:A, "<="&G2)Rows between two dates.
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
📎 Practice files for this article
- 📗SUMIFS/COUNTIFS scenarios workbookConditional sums and counts with dates, OR logic and wildcards, plus 4 classic reasons totals come out wrong — all with PASS/FAIL checks.⬇ XLSX · 9 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong