ExcelCOUNTBLANK Function

COUNTBLANK Function

TheCOUNTBLANK function is a premade function in Excel, which counts blank cells in a range.

It is typed=COUNTBLANK

Note: TheCOUNTBLANK function is helpful to find empty cells in a range.

How to use the=COUNTBLANK function:

1. Select a cell
2. Type=COUNTBLANK
3. Double click theCOUNTBLANK command
4. Select a range
5. Hit enter

Let's see some examples!

Apply the=COUNTBLANK function to rangeC2:C21, to find the Pokemons which do not have a 2nd Type:

NameType 1Type 2Total stats MankeyFighting305 PoliwrathWaterFighting510 VictreebelGrassPoison490 TentacoolWaterPoison335 MagnetonElectricSteel465 DewgongWaterIce475 CloysterWaterIce525 OnixRockGround385 DragonairDragon420 PidgeottoNormalFlying349 RattataNormal253 BeedrillBugPoison395 DoduoNormalFlying310 KinglerWater475 NidoqueenPoisonGround505 HitmonchanFighting455 CharmeleonFire405 ArbokPoison438 GastlyGhostPoison310 MagikarpWater200

Copy Values

COUNTBLANK function, step by step:

1. SelectC23
2. Write=COUNTBLANK
3. Double clickCOUNTBLANK in the menu
4. Select rangeC2:C21
5. Hit enter

TheCOUNTBLANK function successfully counted8 blank cells in the rangeC2:C21.