COUNTIFS in Google Sheets
COUNTIFS counts rows where every condition you list is true across matching ranges — an AND count.
=COUNTIFS(A2:A100, "Paid", B2:B100, ">100")
Counts rows where column A is "Paid" AND column B is over 100.
How it works
COUNTIFS takes range/criterion pairs: range1, criterion1, range2, criterion2, …. A row is counted only if it satisfies all criteria. Every range must be the same size and shape, or you get a #VALUE!.
Variations
Count within a date range
=COUNTIFS(D2:D100, ">="&DATE(2026,1,1), D2:D100, "<="&DATE(2026,3,31))
Two conditions on the same date column bracket a range.
Use a cell for the threshold
=COUNTIFS(A2:A100, F1, B2:B100, ">"&G1)
F1 and G1 hold the criteria.
OR across two values (add COUNTIFS)
=COUNTIFS(A2:A100,"Paid")+COUNTIFS(A2:A100,"Pending")
COUNTIFS is AND-only; add them for OR.
Examples
| Scenario | Formula |
|---|---|
| West region, over target | =COUNTIFS(Region,"West", Sales,">1000") |
| Open tickets assigned to Sam | =COUNTIFS(Status,"Open", Owner,"Sam") |
FAQ
COUNTIF vs COUNTIFS?
COUNTIF handles one condition; COUNTIFS handles many at once (all must be true).
Why do I get #VALUE! from COUNTIFS?
The ranges are different sizes. Make every range span the same rows, e.g. all A2:A100.