View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default 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