Google Sheets COUNTA Function
The COUNTA function is a premade function in Google Sheets, which counts cells that has values, both letters and numbers.
It is typed
=COUNTA and gets a list of cells:
You can select cells one by one, but also ranges, or even multiple ranges.
Counta Function Example
=COUNTA function to range
D2:D21. Counting Pokemons by their names, which are letters only:
COUNTA function, step by step:
- Select the cell
- Click the COUNTA command
- Specify range
- Hit enter
That's it! The
=COUNTA function successfully counted 20 cells with values in the range
Another Example (Numbers)
=COUNTA function to the range
D2:D21, which only has cells with numbers.
That is great! The
COUNTA function counts cells in a range with values both numbers and letters.