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

Hello everyone! In today's video tutorial, you will learn the difference between COUNT and COUNTA functions in Microsoft Excel with a simple step-by-step breakdown.

Understanding when to use COUNT vs COUNTA is essential for accurate data counting in spreadsheets.

📚 Related Tutorial: Learn more foundational formulas in our guide on Top 15 Basic Excel Formulas for Beginners ↗!

📊 Quick Comparison: COUNT vs COUNTA

Function	What It Counts	What It Ignores	Best Used For
`COUNT`	Numbers ONLY (Integers, Decimals, Dates)	Text, Blank cells, Errors	Counting numeric values (e.g., scores, prices, IDs)
`COUNTA`	ANY DATA (Numbers, Text, Symbols, Dates)	Completely empty / blank cells	Counting total rows with entries (e.g., student names, product lists)

🛠️ 1. What is COUNT Function in Excel?

The COUNT function counts only cells that contain numeric values (numbers, percentages, dates, currency). It completely ignores text and empty cells.

Syntax:

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

Example:

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

=COUNT(A1:A5)

Result: 3 (it counts only 100, 250, and 400).

🛠️ 2. What is COUNTA Function in Excel?

The COUNTA function counts all non-empty cells regardless of data type (numbers, text strings, dates, logical TRUE/FALSE values, or symbols).

Syntax:

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

Example:

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

=COUNTA(A1:A5)

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

💡 Pro Tips for Counting Data

Use COUNTA for Text & Name Lists: Never use COUNT to count student names or employee lists because COUNT ignores text and returns 0! Always use COUNTA.
Watch Out for Invisible Spaces: Cells containing space characters (" ") or empty text formulas ("") are counted by COUNTA. Use TRIM to clean unwanted spaces.
Use COUNTBLANK for Empty Cells: If you want to count how many cells are completely missing data, use =COUNTBLANK(range).