Mastering COUNTIFS in Excel – Count with Multiple Conditions Easily

COUNTIFS lets you count entries based on two or more conditions — perfect for filtered summaries, reports, or tracking tasks.

🔹 Syntax:

=COUNTIFS(range1, criteria1, [range2, criteria2], ...)

🔹 Example:

To count completed tasks in the HR department:

=COUNTIFS(A2:A20, "HR", B2:B20, "Completed")

👉 A2:A20 = Department 👉 B2:B20 = Task Status

🔹 Use Cases:

• 📝 Count tasks by project and status
• 📊 Count sales by region and product
• 📅 Count attendance by name and date

🔹 Tips:

• ✅ Use cell references for flexible filtering
• 📈 Combine with dropdowns and dashboards
• 💡 For summing values, use SUMIFS instead

🔚 Wrap-Up:

COUNTIFS is a powerful way to filter and count your data precisely — a must-have in your Excel toolkit.

📌 Save this blog and follow @ScriptDataInsights for more Excel formulas, templates, and dashboard techniques!