COUNTBLANK Formula in Excel
Thursday, Jun 25
commerce curve online accounting course

How to Use the COUNTBLANK Formula in Excel

The COUNTBLANK formula in Excel is used to count the blank cells within a selected range.

Depending on the analysis that you’re performing, this could come in handy as you do not have to manually

Formula explanation:

• Range: The range from which you want to count the blank cells.


In this example, we are going to count the blank cells from the number table below.

Formula Implementation:

* Note this table is only a sample of an example with a few data entries, and the formulas are based on the whole population of raw data which are not reflected in the example.


I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!



Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

1 + 6 =