Goal: Count how many valid entries are in the list.
COUNT: Only counts Numbers.
COUNTA: Counts Anything (except empty cells).
Ready...
💻 Formula Structure
=COUNT(value1, [value2], ...)
- Logic: Counts cells containing Numbers (including Dates & Percentages).
- Ignores: Text, Empty cells, and Logical values (in ranges).
=COUNTA(value1, [value2], ...)
- Logic: Counts Anything that is not empty.
- Includes: Numbers, Text, Errors, Booleans, Formulas returning "".
-- Select a function...
...
⚠️ Common Pitfalls
🚫 The "Invisible" Space
A cell containing just a space " " looks empty, but COUNTA counts it! This often happens with bad data imports.
📅 Dates are Numbers
Excel stores dates as serial numbers (e.g., 45000). Therefore, COUNT will include them.