How to Use Excel’s COUNTIF Function to Count Based on Conditions

How to Use Excel’s COUNTIF Function to Count Based on Conditions

The COUNTIF() function in Excel is a powerful tool for counting cells that meet specific criteria. Whether you’re working with scores, categories, or text, this function makes data analysis faster and more meaningful.

🔹 Syntax:

=COUNTIF(range, criteria)

✅ Example:

=COUNTIF(B2:B20, "Pass")

This will count how many cells in range B2 to B20 contain the word "Pass".

💡 Use Cases:

• Count students who passed an exam
• Track sales from a particular region
• Count how many products are "Out of Stock"

✨ Pro Tip:

You can also use operators like ">50" or text wildcards like "A*" (starts with A) as your criteria!

For more Excel function breakdowns and real-world dashboards, follow ScriptDataInsights today!