Syntax
COUNT(value1, [value2, ...])
| Parameter | Description |
|---|---|
| value1 | Parameter of the COUNT function. |
| [value2 | (Optional.) Parameter of the COUNT function. |
| ...] | Parameter of the COUNT function. |
Examples
Count how many cells have numbers
Formula
=COUNT(B2:B100)
Returns: 47 — the number of cells containing numeric values in the range
Count dates in a range
Formula
=COUNT(D2:D50)
Returns: 35 — dates are stored as numbers internally, so COUNT includes them
Check data completeness
Formula
=COUNT(B2:B100)/COUNTA(A2:A100)
Returns: 0.94 — 94% of rows with names also have a corresponding numeric value
Common Errors
Returns 0
All cells contain text, not numbers. Numbers formatted as text (left-aligned) are not counted. Convert with VALUE().
Tips
COUNT vs COUNTA
COUNT counts only numbers. COUNTA counts any non-empty cell (text, numbers, errors). Use COUNTA for general non-blank counting.
COUNT vs COUNTIF
COUNT counts all numbers. COUNTIF counts cells matching specific criteria. Use COUNTIF for conditional counting.
Count blanks
Use COUNTBLANK(A1:A100) to count empty cells, or =ROWS(A1:A100)-COUNT(A1:A100) for cells without numbers.
Try COUNT in Viztab
Import your data and use COUNT with 370+ other formulas. No signup required.
Open Viztab