Mastering the COUNTIFS Function in Excel (Multiple Criteria Counting)

Mastering the COUNTIFS Function in Excel (Multiple Criteria Counting)

The COUNTIFS() function helps you count how many rows meet multiple conditions at once. It’s a game-changer when analyzing filtered data.

🔹 Syntax:

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

✅ Example:

=COUNTIFS(A2:A100, "HR", B2:B100, "Pass")

This will count how many people in the “HR” department have a status of “Pass”.

💼 Use Cases:

• HR: Count employees who passed training in specific departments
• Sales: Count deals won by region and quarter
• Education: Count students who scored above 80 and passed attendance

🚀 Pro Tip:

Pair COUNTIFS with dynamic named ranges or slicers to create powerful dashboards in Excel.

Want more smart Excel techniques? Follow ScriptDataInsights for daily formula breakdowns and dashboard strategies.