How to Use Excel COUNTBLANK Function (Examples + Video)

Excel COUNTBLANK Function (Example + Video)

Excel COUNTBLANK Function

When to use Excel COUNTBLANK Function

COUNTBALNK function can be used when you have to count all the empty cells in a range.

What it Returns

It returns a number that represents the number of cells that are empty.

Syntax

=COUNTBLANK(range)

Input Arguments

  • range – it is the range in which you want to count the blank cells.

Additional Notes

  • Cells with formulas that return “” (empty text) are considered blank and are counted.
  • Cells that contain, text, numbers, errors, etc. are not counted.
  • Cells that contain zero are considered not blank and will not be counted.

Excel COUNTBLANK Function – Live Example

Related Excel Functions:

You May Also Like the Following Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

1 thought on “How to Use Excel COUNTBLANK Function (Examples + Video)”

Leave a Comment