Kiến thức

# Counting Blank or Empty Cells in Excel

Bạn đang xem: Count Blank or Empty Cells in Excel

## Excel COUNTBLANK function

Excel offers several count functions that quantify the number of cells in a selected

range

that contain a specific type of data.

The job of the COUNTBLANK

function

is to count the number of cells in a selected range that either contains no data or contains a formula that returns a blank or null value

## Syntax and Arguments

A function’s

syntax

refers to the layout of the function and includes the function’s name, brackets, comma separators, and

arguments

.

The syntax for the COUNTBLANK function is:

` =COUNTBLANK(range)`

The range, which is a required argument, is the group of cells the function must search. The range argument must be a contiguous group of cells.

Since COUNTBLANK does not permit multiple ranges to be entered for the range argument, several instances of the function may be entered in a single formula to find the number of blank or empty cells in two or more non-contiguous ranges. For example:

` =COUNTBLANK(A2:A10) + COUNTBLANK(B2:B10)`

## Alternative Using CountIf

Excel supports more than one way to arrive at your intended, correct answer. For example, the formula

` =COUNTIF(A2:A10,"")`

uses the COUNTIF function to find the number of blank or empty cells in the range A2 to A10 and gives the same results as COUNTBLANK.