Using COUNTIF in Excel to Count Based on a Condition (With Practical Cases)

Using COUNTIF in Excel to Count Based on a Condition (With Practical Cases)

COUNTIF() is one of Excel’s most commonly used formulas to count how many times a value appears in a range. It’s perfect for analyzing categories, attendance, or any data requiring filtered counts.

📘 Syntax:

=COUNTIF(range, criteria)

✅ Example – Count Students Who Passed:

=COUNTIF(C2:C100, ">=40")

This counts how many students scored 40 or above.

🎯 Practical Use Cases:

• Track how many employees took leave on a specific day
• Count how many orders were above a certain amount
• Check how many products belong to a certain category

💡 Bonus Tip:

You can also use wildcards in COUNTIF! Example: =COUNTIF(A2:A100, "*Excel*") counts all cells that contain the word "Excel".

🔁 Related Formulas:

Try using COUNTIFS() when you need to apply multiple conditions.

Keep mastering Excel step by step with ScriptDataInsights. Learn formulas that power your insights.