formulas that may sometimes contain empty cells
Say we are adding A1 thru A10, but if any are blank, report 0 instead:
=IF(COUNTBLANK(A1:A10)0,0,SUM(A1:A10))
So you will see 0 until all the data is filled in.
--
Gary''s Student - gsnu200829
"chrisnsmith" wrote:
How do you get a formula that contains empty cells to ingnore the formula and
return a value of 0 (zero)
|