Hide #VALUE! Error

[Unexpc]

Hi guys
i have a SUM formula that total of three link cells and when link cells is empty, SUM formula show value erroring
how hide this error?
i have 3 different formula for SUM in the specific cells
for example in E8 : =SUM(C8+D8) , E9 : =SUM(E8+C9)+D9 , E42 : =SUM(C42+D42,Sheet1!E39) *Sheet1 is my worksheet not other sheet

 

[Fluff]

Try

=SUM(C8:D8)
=SUM(C9:D9,E8)
=SUM(C42:D42,E39)

 

[Unexpc]

Try

=SUM(C8:D8)
=SUM(C9:D9,E8)
=SUM(C42:D42,E39)

Thank You this simple than mine

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Unexpc]

onething, i want generally hide this cells, for example in E9 : =SUM(C10:D10,E9) and when i drag and fill down, it shows last number in E9, because C10 and D10 is last fill cells and next cells still empty for doing sum in E10,E11,... i want after cells from E9 (or like cells this) hide and show empty, any function exist that doing this?

 

[Fluff]

How about

=IF(AND(C9="",D9=""),"",SUM(C9:D9,E8))

 

[Unexpc]

Correct, Thank You Again

 

[Fluff]

My pleasure.