BeginnerStatistical Functions
Count how many orders shipped with COUNT
Use COUNT to find how many rows contain a numeric value.
COUNT
4 min10 points
COUNT
Counts how many cells in a range contain numbers.
Syntax
COUNT(value1, [value2], ...)
Statistical Functions.
A worked example
=COUNT(D2:D9)
Returns 5
Counts only the cells holding numbers, so the three empty ones are excluded.
Where it goes wrong
COUNT ignores text. A column of numbers stored as text counts as zero, which looks like missing data rather than a formatting problem.
Consider instead: COUNTA, when you want every non-empty cell regardless of type.
Practise COUNT
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All COUNT practice exercises →