1. column
  2. TECHNOLOGY Q&A

An Easy Way To Count The Blanks

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

No Results

TOPICS

    Uncategorized Article

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.