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:
• Google Sheets Count | How to Use COUN...
COUNTIF function tutorial:
• COUNTIF Google Sheets | How to Use CO...
COUNTIFS function tutorial:
• How to use COUNTIFS in Google Sheets ...
COUNTUNIQUE function tutorial:
• Google Sheets COUNTUNIQUE Function | ...
COUNTUNIQUEIFS function tutorial:
• google sheets countuniqueifs count un...
COUNTA function tutorial:
• Google Sheets COUNTA Function | Count...
----------------------------------------------------
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.