Functions
COUNT
Count numeric values
Try it
When to use it
When should I use COUNT instead of COUNTA?
Use COUNT to count only numeric values; use COUNTA to count every non-empty value, including text.
Does COUNT count text or blank cells?
No. COUNT ignores text, logical values, and empty cells, and only tallies entries that are numbers.
Use cases
Count numeric responses in a survey row
Count completed numeric readings
Used in
operations · finance · education
Syntax
COUNT(value1,...)Examples
=COUNT(1,2,3,4,5) // => 5
=COUNT(4,26,1,2,3) // => 5