Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

Google Sheets COUNTBLANK Function


COUNTBLANK Function

The COUNTBLANK function is a premade function in Google Sheets, which counts blank cells in a range.

It is typed =COUNTBLANK and gets a list of cells:

=COUNTBLANK(value1, [value2, ...])

You can select cells one by one, but also ranges, or even multiple ranges.

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


Countblank Function Example

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

Copy Values

COUNTBLANK function, step by step:

  1. Select the cell C22
  2. Type =COUNTBLANK
  3. Click the COUNTBLANK command

  1. Specify range C2:C21
  2. Hit enter

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