Countif vs Countifs Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use COUNTIF and COUNTIFS formula in Excel step by step with simple examples and video speak Khmer.

You ever want to count how many items in your list meet a specific condition? For example, count how many students passed exam or how many items are out of stock? Excel have formula called COUNTIF for single condition. But if you want to check two or more conditions at the same time (like count male students who passed exam), you need to use COUNTIFS formula!

Let's look at how to use both function below.

1. How to Use COUNTIF Formula in Excel

COUNTIF function help you count how many cell in a range meet a single criteria. Very simple and easy to use.

Formula Syntax:

=COUNTIF(range, criteria)

Example:

If you want to count how many students have score greater than 80 in column B2:B10:

• Range: B2:B10 (score column)
• Criteria: ">80" (greater than 80)

Formula:

=COUNTIF(B2:B10, ">80")

Watch video below for step by step guide in Khmer:

2. How to Use COUNTIFS Formula in Excel

COUNTIFS function allow you to count how many cell in multiple ranges meet multiple conditions at the same time. Very powerful for big dataset!

Formula Syntax:

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Example:

If you want to count how many Male students have score greater than 80:

• Criteria_range1: A2:A10 (gender column)
• Criteria1: "Male"
• Criteria_range2: B2:B10 (score column)
• Criteria2: ">80"

Formula:

=COUNTIFS(A2:A10, "Male", B2:B10, ">80")

Watch video below for full guide in Khmer:

3. Video Tutorial: COUNTIF vs COUNTIFS Comparison (Khmer)

Watch full comparison video below to understand difference between COUNTIF and COUNTIFS clearly in Khmer:

💡 Quick Tip: COUNTIF is for one condition only, while COUNTIFS can handle 1 up to 127 criteria pairs! Because COUNTIFS works for single condition as well, many Excel professionals prefer using COUNTIFS all the time so they don't need to change formula later when adding extra conditions!

📚 Useful Resources

• How to Calculate Number of Students (Male/Female, Pass/Fail) in Excel
• How to Count and Find Unique Values in Excel
• XLOOKUP vs INDEX+MATCH Function in Excel (Video in Khmer)
• Top 15 Basic Excel Formulas Every Beginner Should Know
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)