COUNTBLANK Function
The COUNTBLANK function is a premade function in Excel, which counts blank cells in a range.
It is typed =COUNTBLANK
Note: The COUNTBLANK function is helpful to find empty cells in a range.
How to use the =COUNTBLANK function:
- Select a cell
- Type
=COUNTBLANK - Double click the COUNTBLANK command
- Select a range
- Hit enter
Let's see some examples!
Apply the =COUNTBLANK function to range C2:C21, to find the Pokemons which do not have a 2nd Type:
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
COUNTBLANK function, step by step:
- Select
C23 - Write
=COUNTBLANK - Double click COUNTBLANK in the menu
- Select range
C2:C21 - Hit enter
text
The COUNTBLANK function successfully counted 8 blank cells in the range C2:C21.