COUNTBLANK

Excel-countblank-function

Related Functions

Sponsored Link

Purpose 

Count cells that are blank

Return value 

A number representing blank cells

Syntax 

=COUNTBLANK (range)

Arguments 

  • range - The range in which to count blank cells.

Usage notes 

Use the COUNTBLANK function to count blank cells in a range. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.

COUNTBLANK counts the number of cells in the range that don't contain any value and returns this number as the result. Cells that contain, text, numbers, errors, etc. are not counted.

Cells that contain formulas that return empty text ("") are considered blank and will be counted.

Cells that contain zero are considered not blank and will not be counted.

Sponsored Link

0 votes. 0 / 5