Formula Guide
COUNTIF Formula Helper
COUNTIF counts cells that meet a single condition. COUNTIFS extends this to multiple criteria. Essential for data analysis, reporting, and dashboards.
What It Does
Counts the number of cells in a range that meet specified criteria.
Syntax
=COUNTIF(range, criteria) =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...) Partial match: =COUNTIF(A2:A100, "*keyword*")
Example
Example: Count orders from West region =COUNTIF(B2:B100, "West") Count orders from West with sales > 1000 =COUNTIFS(B2:B100, "West", C2:C100, ">1000") Data: | Order | Region | Amount | | 001 | West | 5000 | | 002 | East | 3000 | | 003 | West | 500 | COUNTIF Result: 2 COUNTIFS Result: 1
Pro Tips
- Use wildcards (* and ?) for partial text matching
- Combine with UNIQUE or SUMPRODUCT for counting unique values
- Use "<>" to count non-empty cells matching criteria
- COUNTBLANK counts empty cells if that's what you need
Try the AI COUNTIF Generator
Pre-filled with: “Count cells that contain a specific word”