December 4, 2020

COUNTBLANK function in Google Sheet

The COUNTBLANK function is used to count the number of blank cells within a supplied range of cells or values in both Excel & Google Sheet.

=COUNTBLANK(range)
  • Here the argument range can be values, arrays of values, or references to cell ranges within which you want to count the number of cells that are empty.

In Below example we have used the COUNTBLANK function to count Blank cells in each column and in the entire table.

Leave a Reply

Your email address will not be published. Required fields are marked *