COUNTIFS Generator - Count with Multiple Criteria | Excel & Sheets
Counts cells that meet multiple criteria. Essential for data analysis with complex conditions.
Common Errors & Fixes
COUNTIFS returns 0 or unexpected count
Causes:- Criteria ranges have different lengths.
- Text criteria not in quotes; number criteria wrong format.
Fixes:- Use identical range sizes: A1:A100, B1:B100.
- Use "Completed", ">100", "="&A1 for text, number, and cell reference.
Frequently Asked Questions
Why does COUNTIFS return 0?
All conditions must be met in the same row. Check that criteria ranges are the same size and that criteria match data types (text in quotes, numbers with ">50" etc).
Do COUNTIFS ranges have to be the same size?
Yes. Each criteria range must have the same number of rows (and columns). Mismatched range sizes can give wrong counts or errors.
Can COUNTIFS count with OR logic?
COUNTIFS is AND logic only. For OR, add multiple COUNTIFS: =COUNTIFS(A:A,"X")+COUNTIFS(A:A,"Y"), or use SUMPRODUCT with (condition1)+(condition2).
How do I count rows where one column is blank and another is not?
Use criteria "" for blank and "<>" for non-blank: =COUNTIFS(A:A,"", B:B,"<>").
What is the difference between COUNTIF and COUNTIFS?
COUNTIF has one condition; COUNTIFS has multiple criteria_range/criteria pairs. Use COUNTIFS when you need two or more conditions at once.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More