How it works.
COUNTIFS counts the number of cells in one or more ranges that meet a set of conditions. You can add up to 127 criteria ranges and conditions.
💡 In simple terms.
Counts how many cells in one or more ranges meet specific conditions.
Analogy
"Think of this like counting toys. It counts only the toys that match your description (like counting only red blocks, ignoring blue cars and red balls)."
Syntax guide.
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Parameters
criteria_range1Required
The first range to apply the first condition against.
criteria1Required
The condition to check in criteria_range1.
criteria_range2Optional
The second range to evaluate.
criteria2Optional
The condition to check in criteria_range2.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
Best Practices
- Use wildcards like "?" (matches single char) and "*" (matches any sequence) to count partial text matches.
- Use COUNTIFS to count blanks using double quotes: "" or non-blanks using "<>".
Common Gotchas
- Just like SUMIFS, all criteria ranges must be the exact same height and width, or the function fails with a #VALUE! error.