August 2, 2021

COUNTBLANK function in Excel

In this lesson we will learn how the COUNTBLANK function works in Excel. The COUNTBLANK function is used to count the number of blank cells within a supplied range of cells or values.

=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.

Let’s understand with a simple example. In below table we have 2 different set of values in column A & B.

Now in cell E1 we have added the below formula.

=COUNTBLANK(A2:A6)

This will calculate the number of blank cells in the cell range A2:A6 and returned the count 2 in cell E1.

In the same way we have used the COUNTBLANK formula in cell E2 & E3 to count the no. of blank cells in cell range B2:B6 and A2:B6 respectively.

You can also check here to understand how the COUNTBLANK function works in Google Sheet.

You can also check here to understand how the COUNTIF function works in Google Sheet.

You can also check here to understand how the COUNTIF function works in Excel.

You can also check here to understand how the COUNTA function works in Google Sheet.

You can also check here to understand how the COUNTA function works in Excel.

You can also check here to understand how the COUNTIFS function works in Google Sheet.

You can also check here to understand how the COUNTIFS function works in Excel.

Leave a Reply

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