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
|