Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count rows that meet two criteria in Excel and Google Sheets
Excel & Google Sheets
=COUNTIFS(A2:A6,"North",B2:B6,"Apple")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Region | Product |
| North | Apple |
| South | Banana |
| North | Apple |
| East | Apple |
| North | Cherry |
=COUNTIFS(A2:A6,"North",B2:B6,"Apple")→2
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the output cell.
- 2Type =COUNTIFS(.
- 3Enter the first criteria range (e.g. A2:A6), a comma, then the first criterion ("North").
- 4Add another comma, enter the second criteria range (B2:B6), a comma, then the second criterion ("Apple").
- 5Close the parenthesis and press Enter. All pairs are evaluated with AND logic — a row is counted only when all criteria match.
Tips
- All criteria ranges must have the same number of rows/columns.
- Criteria can mix text, numbers, and comparisons: e.g. A2:A6,"North",C2:C6,">100".
- COUNTIFS uses AND logic. For OR logic, add two COUNTIFS results together.
- Available in Excel 2007+ and all Google Sheets versions.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
How do I count rows that meet criterion A OR criterion B?
Add two COUNTIFS: =COUNTIFS(A2:A6,"North",B2:B6,"Apple")+COUNTIFS(A2:A6,"South",B2:B6,"Apple"). Subtract double-counted rows if needed with a third COUNTIFS.
Can I use wildcards in COUNTIFS?
Yes. Wildcards (* and ?) work the same as in COUNTIF.