How do I count rows that meet more than one condition across different columns?
COUNTIFS counts a row only when every condition you list is true at the same time (an AND across columns): =COUNTIFS(range1, criteria1, range2, criteria2, ...). Add one range/criteria pair per column you need to check.
Formula (Excel and Google Sheets)
=COUNTIFS(A:A,"Northeast",B:B,"Open",C:C,">"&DATE(2026,1,1))Each range/criteria pair in COUNTIFS is one condition, and a row is only counted if it satisfies all of them at once. The example above counts rows where column A is "Northeast" AND column B is "Open" AND column C is a date after January 1, 2026. Every range must be the same size and cover the same rows, or the count will not line up correctly.
COUNTIFS only combines conditions with AND. If you need an OR (for example, region is "Northeast" OR "Southeast"), add a second COUNTIFS for the other condition and add the two results together, or switch to SUMPRODUCT, which can express OR logic directly.
Step by step
- 1
List every condition you need
Write out, in plain English, each column and the value or comparison it must match.
- 2
Pair each range with its criteria
=COUNTIFS(range1, criteria1, range2, criteria2, ...), keeping every range the same size.
- 3
For OR logic, add separate COUNTIFS results together
e.g. =COUNTIFS(A:A,"Northeast",...) + COUNTIFS(A:A,"Southeast",...), or use SUMPRODUCT for a single formula.
Common questions
What happens if my ranges are different sizes?
COUNTIFS returns a #VALUE! error if the ranges are not all the same size and shape. Make sure every range covers the exact same rows.
Can COUNTIFS count an OR condition directly?
No, COUNTIFS only combines conditions with AND. For OR logic, add multiple COUNTIFS formulas together or use SUMPRODUCT.
Related formulas
How to Use COUNTIF and COUNTIFS in Excel and Google Sheets
RelatedHow to Use SUMIF and SUMIFS in Excel and Google Sheets
RelatedHow to Use SUMPRODUCT for Weighted Totals and Multi-Condition Counts
From the blogHow to Make Sense of Your Spreadsheet Data Without Being an Analyst
Want a formula written for your exact spreadsheet, not a generic example?
Try the free formula generator