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.
Practise COUNT1 interactive exercise, free, no account needed
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.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- COUNTA counts anything that is not empty, including text. Here you want only the rows holding a number, which is what COUNT does.Count how many orders shipped with COUNT
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 →