Statistical Function - COUNTBLANK

Another way to count stuff in your spreadsheet is COUNTBLANK... or count any blank cells within a range of data.

The video shows the COUNTBLANK function in use.

The final written calculation is below:

=COUNTBLANK(C3:C9)

In this formula, C3:C9 is the range of cells we are looking for blanks in.