if no data in cell show as blank
Thank you very much, that worked great
--
George
"Suresh Sadanandan" wrote:
Hi George,
try this formula instead:
=IF(SUM(F803:F808)=0,0,SUM(F803:F808)+H799)
it returns a 0 if the sum range is balank, if you want a balnk cell, replace
the 0 inbetween the two comas with ""
Regards,
Suresh
"George" wrote:
Iv got the following formula in cell H803:
=SUM(F803:F808)+H799
Is there a way that if there is no data in any of these cells (F803:F808).
Cell H803 remains blank.
--
George
|