How to Use COUNTIF and COUNTIFS Function in Excel (Video in Khmer)

Hello everyone! Today I show you very easy step-by-step how to use COUNTIF and COUNTIFS function in Microsoft Excel and follow these videos to learn. In these videos I explain in Khmer language.

COUNTIF and COUNTIFS functions help you count how many cells or numbers in your table database match specific conditions. Very useful when you want to count total male or female students, count passed exams, or count product stock in database!

📚 Related Tutorial: Want to count values using database criteria range? Check out How to Use DCOUNT vs DCOUNTA Function in Excel ↗!

🛠️ Section 1: How COUNTIF Function Work?

The COUNTIF function count number of cells in a single range that meet one condition (criteria).

Formula Syntax:

=COUNTIF(range, criteria)

📺 COUNTIF Example #1: Count Text Value

If you have list of students and want to count how many "Male" students in column A2:A10:

=COUNTIF(A2:A10, "Male")

Watch video below for step-by-step explanation in Khmer:

📺 COUNTIF Example #2: Count Number with Condition

If you want to count how many students passed exam with score greater than or equal to 50 in column B2:B10:

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

Watch video below for more COUNTIF examples in Khmer:

💡 Pro Tip: You can also use wildcard character "*" to count text matching pattern! For example, =COUNTIF(A2:A10, "S*") count all names starting with letter "S".

🛠️ Section 2: How COUNTIFS Function Work?

The COUNTIFS function allow you to count cells that meet multiple conditions (2 or more criteria) across different ranges at the same time.

Formula Syntax:

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

📺 COUNTIFS Example #1: Count with Multiple Criteria

If you want to count how many "Female" students scored greater than or equal to 50:

• criteria_range1: A2:A10 (Gender column)
• criteria1: "Female"
• criteria_range2: B2:B10 (Score column)
• criteria2: ">=50"

=COUNTIFS(A2:A10, "Female", B2:B10, ">=50")

Watch video tutorial below in Khmer:

📺 COUNTIFS Example #2: COUNTIF vs COUNTIFS Comparison

Watch full video below to understand difference between COUNTIF and COUNTIFS clearly step-by-step in Khmer:

⚠️ Important Note: Logical operators like >, <, >=, <=, <> must be put inside double quotes " ". If you refer to cell value like cell C1, use ampersand & to join: ">=" & C1.

💡 Quick Summary: COUNTIF is for 1 condition only, while COUNTIFS can handle 1 up to 127 criteria pairs. Many Excel users prefer using COUNTIFS all the time because easy to add more conditions later without changing formula name!

📚 Related Resources (Open in New Tab):

• COUNTIF vs COUNTIFS Function in Excel (Video in Khmer) ↗ — Deep dive comparison post and video guide.
• How to Use AVERAGEIF Function in Excel ↗ — Calculate average based on specific condition.
• How to Use SUMIF and SUMIFS Function in Excel ↗ — Sum numbers matching single or multiple criteria.
• How to Count and Find Unique Values in Excel ↗ — Count distinct and unique values in Excel table.
• Top 15 Basic Excel Formulas for Beginners ↗ — Master essential Excel formulas step-by-step.