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 match a condition in Excel and Google Sheets
Excel & Google Sheets
=COUNTIF(B2:B6,">50")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Region | Sales |
| North | 80 |
| South | 45 |
| North | 60 |
| East | 30 |
| West | 75 |
=COUNTIF(B2:B6,">50")→3
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
- 1Identify the column(s) to evaluate and the condition(s) to apply.
- 2For one condition, use =COUNTIF(B2:B6,">50").
- 3For two conditions, use =COUNTIFS(A2:A6,"North",B2:B6,">50").
- 4Criteria operators include: >, <, >=, <=, <>, =, and wildcards * and ?.
- 5Press Enter to see the count.
Tips
- Put comparison operators inside quotes: ">50" not >50.
- To reference a cell for the threshold: ">"&C1.
- COUNTIFS adds AND logic; for OR logic, sum multiple COUNTIF/COUNTIFS results.
- COUNTIF is available since Excel 2003; COUNTIFS since Excel 2007.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is the difference between COUNTIF and COUNTIFS?
COUNTIF takes one range and one criterion. COUNTIFS takes multiple range-criterion pairs and counts rows that satisfy all of them simultaneously (AND logic).
How do I count rows where a cell is not empty?
Use =COUNTIF(A2:A6,"<>") to count non-empty cells.