1. column
  2. TECHNOLOGY Q&A

The Right Way To Count The Zeros

BY STANLEY ZAROWIN

Please note: This item is from our archives and was published in 2005. 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

In the April issue (page 81) I wrote that unchecking Zero values (under Options , View ) would affect a count of zero values. Several readers pointed out that it only affects whether the zeros are visible, not the actual count. Use the COUNTBLANK formula to count empty cells.