Google Sheets COUNTBLANK Function | Count Empty Cells | How to Use COUNTBLANK

The Google Sheets COUNTBLANK function returns the count of empty cells in the specified range(s). This function requires a range as the mandatory attribute. If you want to count empty cells in additional range(s), specify these as second, third, and other attribute(s).

----------------------------------------------------
If you are interested in the COUNT, COUNTIF, COUNTIFS, COUNTUNIQUE, COUNTUNIQUEIFS, or COUNTA function, here are the links to the step-by-step video tutorials:

COUNT function tutorial:
https://youtu.be/Yd2lCZB3WfE

COUNTIF function tutorial:
https://youtu.be/ItttED6r9pc

COUNTIFS function tutorial:
https://youtu.be/urrL985PvRk

COUNTUNIQUE function tutorial:
https://youtu.be/tBiC5h24QZw

COUNTUNIQUEIFS function tutorial:
https://youtu.be/y28QwIbs0fg

COUNTA function tutorial:
https://youtu.be/kFIOgmZdnL4
----------------------------------------------------

Let's look at the format of the Google Sheets COUNTBLANK function formula:

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

Start the formula with an equal-to symbol.

COUNTBLANK is the name of the function.

value1 is the range in which to count for empty cells.

value2, and subsequent values, is optional, and is the second range to count for empty cells.

Here are examples of the COUNTBLANK function:

Example 1

=COUNTBLANK(a2:c10)

This function formula returns the count of empty cells, if any, in the range that spans from cell a2 to c10.

Example 2

=COUNTBLANK(a2:c10, e2:g25)

The above function formula returns the total count of empty cells, if found, in the two ranges a2 to c10 and e2 to g25.

Note that if there are spaces in an otherwise empty cell, COUNTBLANK doesn't consider such a cell as an empty cell. So, first make sure there are no spaces in empty cells you want to count, and then use the COUNTBLANK function.

Checkout this video tutorial, which gives the steps to use the Google Sheets COUNTBLANK function with examples.