Formula guide · Excel and Google Sheets · Updated May 13, 2026
COUNTIFS with Multiple Criteria
Use COUNTIFS to count rows that match multiple conditions.
Quick Answer
COUNTIFS counts rows where all listed criteria are true.
Copyable Formula
=COUNTIFS(B2:B50,"West",C2:C50,"Paid")Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)Excel and Google Sheets
Worked Example
| B | C |
|---|---|
| Region | Status |
| West | Paid |
| West | Open |
| West | Paid |
Result: Returns 2 for two West rows with Paid status.
Steps
- Choose the first criteria range.
- Enter the condition for that range.
- Add more range-condition pairs for each extra rule.
Common Mistakes
- Trying to count with OR logic without adjusting the formula.
- Using criteria ranges with different heights.
- Counting visible rows after filtering when COUNTIFS still counts hidden matches.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.