If you have an Excel worksheet you might want to know how many blank cells you have in a range, blank cells are cells that have nothing typed into them, this could be cells that have not been used or the value in it has been cleared. Sometimes a space may have been typed, the cell will look blank but in fact it is not, it is just that a space on its own is not really visible. It could be there is data missing and it needs to be filled in. The COUNTBLANK function can do that. Here Gary Schwartz from www.jargonfreehelp.com shows us how.