Excel COUNTBLANK Function


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:

  1. Select a cell
  2. Type =COUNTBLANK
  3. Double click the COUNTBLANK command
  4. Select a range
  5. 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:

COUNTBLANK function, step by step:

  1. Select C23
  2. Write =COUNTBLANK
  3. Double click COUNTBLANK in the menu
  4. Select range C2:C21
  5. Hit enter

The COUNTBLANK function successfully counted 8 blank cells in the range C2:C21.




Login
ADS CODE