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 VIDEO

How KPMG is innovating the audit

KPMG's global audit team is using cognitive technology and alliances with tech and university partners to drive audit innovation. See how.

SPONSORED REPORT

States look to unclaimed property for revenue

This free report outlines the escheat process, common types of AUP, how different states are handling it and how companies can plan for potential audits and liabilities.