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.