Google Sheets COUNT Function
The COUNT function is a premade function in Google Sheets, which counts cells with numbers.
It is typed
=COUNT and gets a list of cells:
You can select cells one by one, but also ranges, or even multiple ranges.
Note: The COUNT function only counts cells with numbers, not cells with letters. The COUNTA function is used if the cells have letters.
Count Function Example
=COUNT function to range
D2:D21. Counting the cells of Pokemon Total stats, which is numbers only:
COUNT function, step by step:
- Select the cell
- Click the COUNT command
- Specify range
- Hit enter
That's it! The
=COUNT function successfully counted 20 cells with numbers.
A Non-Working Example
Now, let us try an example that will not work.
=COUNT function to the range
A2:A21, which only has cells with letters.
It returns the value
0, no cells with numbers found. Range
A2:A21 only had cells with letters.