Formula for cells with ""

[hammer2]

Hi all

I have a formula that uses "" as the return where I just want the cell left blank if it does not return a figure above zero. I do not want to use '0' in the cell as the return.

In the attached worksheet I get the #VALUE! return when using the formula I input.

Any ideas please?

[Teethless mama]

In E7: =IF(C7="","",SUM(C$7:C7))

copy down as far as needed.