if no data in cell show as blank
 

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

if no data in cell show as blank
 

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

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

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

if no data in cell show as blank
 

If the entries can be 0 or positive and negative, maybe:
=if(count(f803:f808,h799)=0,"",sum(f803:f808,h799) )

If text entries are ok, you could use =counta()
=if(counta(f803:f808,h799)=0,"",sum(f803:f808,h799 ))



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

--

Dave Peterson