Counting Across Conditions With COUNTIFS

COUNTIFS counts how many rows satisfy several conditions at the same time. Where COUNTIF answers "how many sales were in the East?", COUNTIFS answers "how many East sales happened in January?"

It doesn't add or average anything — it simply tallies the rows that pass every test. That makes it perfect for questions like "how many orders over $100 came from new customers?"

Let's learn its structure and put it to work.

COUNTIFS has no sum_range, because it isn't adding values — it only needs the ranges to test and the criteria to test them against.

• criteria_range1, criteria1 — the first test
• criteria_range2, criteria2 — the second test
• ...and so on, up to 127 pairs

Every argument comes in a tidy range, criteria pair. The result is a single whole number: the count of rows where all conditions are true.