An Easy Way To Count The Blanks


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.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.