Cell to remain blank if another cells contain no data

[Detectiveclem]

I have the following formula entered in cell E7 =IF(OR(ISBLANK(C7),ISBLANK(D7)),"",IF(D7-C7<0, 1+D7-C7, D7-C7))
and have another formula in cell H7 =IF(OR(ISBLANK(F7),ISBLANK(G7)),"",IF(G7-F7<0, 1+G7-F7, G7-F7))
and also another formula in cell K7 =IF(OR(ISBLANK(I7),ISBLANK(J7)),"",IF(J7-I7<0, 1+J7-I7, J7-I7))

I now want another formula in cell L7 which will sum the totals of E7, F7 & J7, but if none of the cells E7, F7 or K7 contain any data I also want L7 to remain blank.

I have tried to emulate the first set of formulas to allow me to do this but every time I don’t seem to get it to work, can anyone please help.

 

[Fluff]

You could use
=IF(SUMPRODUCT(--(DAY($A$7:$A$61)=1),$L$7:$L$61)=0,"",SUMPRODUCT(--(DAY($A$7:$A$61)=1),$L$7:$L$61))

Or you can amend the settings for that sheet to not show 0 results.

 

[Detectiveclem]

Thank you Fluff, I will let you know how I get on.

Much appreciated