Addition & multiplication formula
You'll need to tell us what non-standard settings you are using. By
default, that would return zero. Perhaps you have display of zeroes
suppressed?
--
David Biddulph
"HKaplan" wrote in message
...
Try simplifying the formula as I suggested, leaving out the count
statement. =sum(A1:A20) is all you need to total a column. If the
answer is zero, then the cell will be blank.
|