Skip to main content

COUNTBLANK

Definition of COUNTBLANK

Returns the number of empty cells in a given range.

Sample Usage

COUNTBLANK(A2:C100)

Syntax

COUNTBLANK(range)

  • range - The range in which to count the number of blanks.

See Also

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.

COUNTIF: Returns a conditional count across a range.

COUNTA: Returns a count of the number of values in a dataset.

COUNT: Returns a count of the number of numeric values in a dataset.

To use the COUNTBLANK Formula, simply begin with your edited Excellentable:

Then begin typing the COUNTBLANK formula in the area you would like to display the outcome: 

By selecting the cell range you would like to calculate the COUNTBLANK formula, Excellentable generates the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.