COUNTBLANK function

 

The Klipfolio COUNTBLANK function counts all blank values and returns the count as a single value.

The syntax for the COUNTBLANK function is:

COUNTBLANK( data )

COUNTBLANK example

Let's look at a COUNTBLANK function example.

 

A

1 Apples
2 Apples
3  
4 Pears
5 1

The following example is based on the above text from an Excel spreadsheet:

COUNTBLANK( A:A )

-> [1]

Related links: