Q. I frequently have to count the number of empty cells in a spreadsheet. Do I need to put some identification mark in those cells or can Excel just count the blanks?
A. There’s no need to specially designate empty cells. Excel has a special formula that counts the blanks. It’s =COUNTBLANK(RANGE).
So, if you want to count the blanks, say, between cells A2 and A6, the formula is =COUNTBLANK(A2:A6). But be careful, if there’s a zero or a formula in a cell, it won’t count that cell as a blank.