How to Use COUNTIF in Excel to Track Specific Values (With Real-Life Examples)

How to Use COUNTIF in Excel to Track Specific Values (With Real-Life Examples)

The COUNTIF function is used to count the number of cells that meet a certain condition. It’s super useful for tracking entries like attendance, pass/fail, sales performance, and more.

🔹 Syntax:

=COUNTIF(range, criteria)

🔹 Example 1: Count Students Who Passed

In a marksheet where column B contains grades:

=COUNTIF(B2:B100, "Pass")

This counts how many students have "Pass" status.

🔹 Example 2: Count Entries by Name

To count how many times "John" appears in a list of names (column A):

=COUNTIF(A2:A100, "John")

🔹 Example 3: Count Sales Above ₹5000

To count how many sales were more than ₹5000 in column C:

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

🔹 Use Case Ideas:

• Count tasks marked “Done”
• Count product sales by category
• Count attendance for events

🔹 Excel Tip:

Use quotes for text or operators, like ">100" or "Pending". Don’t forget to double-check ranges!

✅ Conclusion

COUNTIF makes data summaries effortless. It’s especially helpful in dashboards and status trackers.

📥 Download free Excel tracker with COUNTIF pre-applied — coming soon!

For more practical Excel skills, follow ScriptDataInsights.