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.
The Right Way To Count The Zeros
BY STANLEY ZAROWIN
