ReferenceFunctionsMath Functions
COUNT
Counts numeric values across scalars and ranges.
Summary
COUNT evaluates all arguments and counts how many are numeric values.
Numbers, dates, and text representations of numbers (when supplied directly) are counted.
Remarks
- Text values inside ranges are ignored and not counted.
- Blank cells and logical values in ranges are ignored.
Examples
Counting mixed scalar inputs
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3
Counting in a range
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
2
Related functions
FAQ
Why doesn't COUNT include text in a range?
COUNT only counts numeric values; text cells in ranges are ignored.
Can direct text like "12" be counted?
Yes. Direct scalar arguments are coerced and counted when they parse as numbers.
Runtime metadata
Category
Math
Signature
COUNT(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 0).
Arity
min 0, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLYSTREAM_OK
Source