COUNTBLANK Function

Basic Description

The Excel Countblank function returns the number of blank cells in a supplied range of cells.

Synatx: COUNTBLANK( range )

Where the range argument specifies the range of cells in which you want to count blank cells. Note that, if a cell contains an empty text string or a formula that returns an empty text string, this cell is counted as a blank by the Countblank function.

 

Countblank Function Examples

The spreadsheets below shows examples of the Excel Countblank function being used to calculate the number of blank cells in two different cell ranges.

Example 1:

Example of the Excel Countblank Function

– Gives the result 3.
Example 2:

Example of the Excel Countblank Function

– Gives the result 9.

 

Example-3:

Formulas:

Count_Formulas_1

Results:

Count_Result_1

 

Download Documents

Download Excel File

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment