How to Use COUNTIF in Excel
The COUNTIF function helps you count cells that meet a specific condition. It's simple but incredibly useful in dashboards and reports.
📘 Syntax:
=COUNTIF(range, criteria)
✅ Example:
=COUNTIF(B2:B10, "Pass")
This counts how many cells in B2:B10 contain the word "Pass".
💡 Advanced:
=COUNTIF(A2:A100, ">75") → Count scores above 75.
🚀 Bonus Tip:
Combine with IF:
=IF(COUNTIF(B2:B10, "Fail") > 3, "Review Needed", "All Good")
🎁 Download Template
Free COUNTIF sample sheet available at ScriptDataInsights.
📲 Follow @ScriptDataInsights for daily Excel hacks and freebies.
Comments
Post a Comment