How to Use the COUNTIF Function in Excel: Step-by-Step for Beginners

How to Use the COUNTIF Function in Excel: Step-by-Step for Beginners

The COUNTIF() function in Excel helps you count the number of cells that meet a specific condition. It’s a powerful tool for analyzing and summarizing data.

🔹 Syntax:

=COUNTIF(range, criteria)

✅ Example:

=COUNTIF(A2:A10, "Completed")

This formula counts how many times the word "Completed" appears in the range A2 to A10.

💼 Real-World Uses:

• Track completed tasks in project sheets
• Count specific names or departments
• Check how many times a value appears

🚀 Pro Tip:

Use wildcards for partial matches: =COUNTIF(A2:A20, "*Smith") counts all names ending with "Smith".

Follow ScriptDataInsights for more Excel tutorials and smart tricks!