Excel Excel COUNTBLANK function

---

Description

The COUNTBLANK function returns the number of empty cells. The COUNTBLANK function is a built-in statistical function, which can be used as a worksheet function (WS) in Excel.

Syntax and arguments

Formula syntax

COUNTBLANK(range)

Arguments

Range: Required, the range of cells that you want to count the blank cells in.

Return Value

The COUNTBLANK function returns the number of blank cells in a range.

Remarks

The cells that contain empty text “” which is returned by a formula will be counted as empty cells.

Usage

Supposing you need to count the number of empty cells in the range B2:D5, please use this formula:

=COUNTBLANK(B2:D5)

Press Enter key to count the number of empty cells in range B2:D5.

Download Sample File

Click to download COUNTBLANK function sample file

Relative Functions:

• Excel COUNTA Function
  The COUNTA function returns the number of cells that contain number, text, error value or the empty text “”, and excluding the real empty cells.

• Excel COUNT Function
  The COUNT function is used to count the number of cells that contain numbers, or count the numbers in a list of arguments. Take an instance, COUNT(1,2,3,4,11,2,1,0) returns 8.

• Excel COUNTIF Function
  The COUNTIF function is a statistical function in Excel which is used to count the number of cells that meet a criterion.

• Excel COUNTIFS Function
  The COUNTIFS function returns the number of cells that meet one single criterion or multiple criteria. The COUNNTIFS function is one of the built-in statistical function, and it can be used as a worksheet function (WS) in Excel.

Relative Articles:

• Count cells equal to
  If you want to count cells exactly match a given criterion, you can choose the COUNTIF function or the SUMPRODUCT (combine with the EXACT function) function to count cells exactly equal to without case sensitive or with case sensitive.

• Count cells not equal to
  To count the number of cells that contain values that not equal to a specified value, such as below screenshot shown. In Excel, you can use the COUNTIF function to quickly handle this job.

• Count cells equal to x or y
  If you want to count cells as long as that meet at least one of given conditions (OR logic) in Excel, i.e. count cells equal to either x or y, you can use several COUNTIF formulas or combine the COUNTIF formula and SUM formula to handle this job.

---

Excel Productivity Tools