# How to use Excel COUNTBLANK Function

How to use Excel COUNTBLANK Function2016-04-29T10:45:13+00:00

## Quick Intro

Use Excel COUNBLANK Function to count cells which are blank.

In simple words, when you specify a range of cells it will return the number of cells which have no value in it. And, if there is no blank cell in the range it will return “0”.

## Syntax

COUNTBLANK (range)

• range A range of cells from which you want to count blank cells.

## More Information on Excel COUNTBLANK Function

• If there is a zero in a cell, that will consider as a non-blank cell, hence ignored.
• And, if a cell has a formula resulting in an empty (=” “), that will also consider as a non-blank cell.
• Cells contain numbers, text, errors & symbols are ignored.

## Example

In the below example, I have used COUNTBLANK function to count blank cells from the range A2:A8.

In this range, I have total 3 cells which are blank but cell A7 has a formula in it which results in a blank cell. The function has returned 2 as cell A4 & A5 are the only cells which are blank and have no values.

## What’s Next?

To learn more about excel MID function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

You can also use COUNT | COUNTA which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.