COUNTIFS Formula Generator
COUNTIFS counts cells that meet multiple criteria across different columns. Perfect for counting records, tracking metrics, and building dashboard summaries.
Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)Try it — generate a COUNTIFS formula
Examples
Count orders from specific region
=COUNTIFS(B:B, "East")Counts all rows where column B is "East".
Count high-value orders by rep
=COUNTIFS(A:A, "John", D:D, ">500")Counts orders by "John" where the amount exceeds $500.
Tips
- ✓COUNTIFS works like SUMIFS but counts instead of summing.
- ✓Use wildcards: "John*" matches "Johnson", "John Smith", etc.
- ✓To count non-blank cells, use "<>" as the criteria.
Related Formulas
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
AVERAGEIFS
AVERAGEIFS calculates the average of cells that meet multiple criteria. Useful f...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free