FormulaMath
Count rows that match several conditions
Count how many rows meet two or more conditions at once — region AND status AND date — without adding a single helper column.
Last updated
Fill in the blanks
Assembled in your browser — nothing you type is stored or sent anywhere.
Your formula
=COUNTIFS(Sales!B2:B500, "West", Sales!D2:D500, ">100")
Works in both Excel and Google Sheets unless the fine print below says otherwise.
Why it's built this way
- →COUNTIFS takes range/criteria arguments in pairs and ANDs every pair together — a row only counts if it satisfies all of them, which a single COUNTIF can't express.
- →Criteria can mix an exact match ("West") with a comparison operator (">100") in the same formula, because each pair is evaluated independently before the AND.
- →Adding a third condition is just another range/criteria pair on the end — the formula scales without restructuring what's already there.
The fine print
- →Every range argument must be the same size (same number of rows) as the others, or the formula returns a #VALUE! error.
- →Text criteria are case-insensitive and support wildcards (* and ?), which can quietly match more rows than expected on messy data.
- →Works identically in Excel and Google Sheets, wildcard behaviour included.