How to Use COUNT vs COUNTA vs COUNTBLANK Function in Excel (Video in Khmer)

Hello everyone! Today I show you very easy step-by-step how to use COUNT, COUNTA, and COUNTBLANK functions in Microsoft Excel.

Understanding when to use COUNT vs COUNTA vs COUNTBLANK is very important for counting your data accurately without mistakes!

📺 Video 1: Example COUNT and COUNTA in Excel

📚 Related Tutorial: Want to learn basic formulas first? Check out Top 15 Basic Excel Formulas for Beginners!

📊 Quick Comparison: COUNT vs COUNTA vs COUNTBLANK

🛠️ 1. What is COUNT Function in Excel?

The COUNT function counts only cells that contain numbers (such as scores, prices, percentages, or dates). It completely ignores text and empty cells.

Formula Syntax:

=COUNT(value1, [value2], ...)

Simple Example:

If cell range A1:A5 contain [100, "Apple", 250, "", 400]:

=COUNT(A1:A5)

• Result: 3 (counts only numeric values 100, 250, and 400).

🛠️ 2. What is COUNTA Function in Excel?

The COUNTA function counts all non-empty cells regardless of data type (text, names, numbers, dates, or symbols). "A" stands for All or Anything!

Formula Syntax:

=COUNTA(value1, [value2], ...)

Simple Example:

If cell range A1:A5 contain [100, "Apple", 250, "", 400]:

=COUNTA(A1:A5)

• Result: 4 (counts 100, "Apple", 250, and 400, ignoring only the 1 blank cell).

📺 Video 2: Example COUNT, COUNTA, and COUNTBLANK in Excel

🛠️ 3. What is COUNTBLANK Function in Excel?

The COUNTBLANK function counts only empty cells in a selected range. It helps you quickly find missing information in your spreadsheet.

Formula Syntax:

=COUNTBLANK(range)

Simple Example:

If cell range A1:A7 contain [100, "Apple", 250, "", 400, "", "Orange"]:

=COUNTBLANK(A1:A7)

• Result: 2 (counts only the 2 empty cells).

💡 Pro Tips for Counting Data in Excel

1. Use COUNTA for Text & Name Lists: Never use COUNT to count student names or staff lists because COUNT ignores text and returns 0! Always use COUNTA.
2. Watch Out for Invisible Spaces: Cells containing space characters (" ") or empty text formulas ("") are counted by COUNTA. Use TRIM to clean unwanted spaces.
3. Use COUNTBLANK for Missing Data: Use =COUNTBLANK(range) to count how many students are absent or how many fields are not filled out yet.