View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default if no data in cell show as blank

Try this:

=IF(SUM(F803:F808,H799),SUM(F803:F808,H799),"")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"George" wrote in message
...
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