Why you need this
Counts the number of cells that meet multiple criteria. Use this for segmentation analysis.
One-Click Copy
=COUNTIFS(criteria_range1, criteria1, ...)
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel COUNTIFS Formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Common Mistakes
- ✕ Range sizes do not match. Like SUMIFS, every range argument must cover the exact same number of rows.
Best Practices
- ✓ Use wildcards for text. The asterisk (*) matches any sequence of characters, and the question mark (?) matches any single character. Great for categorizing messy text data.
Scalability Warning
Array formulas like COUNTIFS can be performance bottlenecks.
See math Alternatives