Count the number of blank Cells in Excel

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, Excel 2010 or Excel 2013 workbook?

There is a great function in Excel that you can use to do exactly that – count the number of BLANK cells in a range.

Simply type…


(replace range with the range of cells you want to limit your count to).

Note that there is one particular thing that might slip you up with this function.  When using =COUNTBLANK(), Excel is only searching for blank, empty cells.  If you have a space in a cell for example – it might look empty to you, but Excel can see that there is a space – which means it will not think it is blank, and not count it.

‘till next time!

Leave a Reply

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