| Function | What it Counts | Syntax | Example Range | Output Example |
|---|---|---|---|---|
COUNT | Only numeric data | =COUNT(range) | A1(e.g. 1, "Text", 3, "", 5) | =COUNT(A1:A5) → 3 (counts 1, 3, and 5) |
COUNTA | All non-empty cells (numbers, text, etc.) | =COUNTA(range) | A1(e.g. 1, "Text", 3, "", 5) | =COUNTA(A1:A5) → 4 (counts 1, "Text", 3, and 5) |
COUNTBLANK | Only empty cells | =COUNTBLANK(range) | A1(e.g. 1, "Text", 3, "", 5) | =COUNTBLANK(A1:A5) → 1 (counts the empty cell) |
Excel formulas
Function What it Counts Syntax Example Range Output Example COUNT Only numeric data =COUNT(range) A1(e.g. 1, "Text", 3, "", 5) =COUNT(A1:A5) → 3 (counts 1,…
Keep building your data skillset
Explore more SQL, Python, analytics, and engineering tutorials.