COUNTA Function
The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters.
It is typed =COUNTA
How to use the =COUNTA function:
- Select a cell
- Type
=COUNTA - Double click the COUNTA command
- Select a range
- Hit enter
Let's see some examples!
Apply the =COUNTA function to range A2:A21, counting Pokemons by their names, which are letters only:
text
Name Type 1 Type 2 Total stats
Mankey Fighting 305
Poliwrath Water Fighting 510
Victreebel Grass Poison 490
Tentacool Water Poison 335
Magneton Electric Steel 465
Dewgong Water Ice 475
Cloyster Water Ice 525
Onix Rock Ground 385
Dragonair Dragon 420
Pidgeotto Normal Flying 349
Rattata Normal 253
Beedrill Bug Poison 395
Doduo Normal Flying 310
Kingler Water 475
Nidoqueen Poison Ground 505
Hitmonchan Fighting 455
Charmeleon Fire 405
Arbok Poison 438
Gastly Ghost Poison 310
Magikarp Water 200
COUNTA function, step by step:
- Select
A23 - Type
=COUNTA - Double click COUNTA in the menu
- Select range
A2:A21 - Hit enter
text
The COUNTA function has successfully counted 20 cells with values in the range A2:A21.
Lets apply the COUNTA function to D2:D21. Counting a range with numbers only.
That is great! The COUNTA function counts cells in a range with values both numbers and letters.