=IF(D10:F10=0,0,SUM(D10:F10))

row 10, cells D, E , F are the SUM for G10.  If I want to keep G10 blank if no value has been entered in D10, E10 and F10.

I know how to do a single cell with no value i.e. =IF(D10=0,0,SUM(D10:F10)) ; excel accepts this formula.  But how do I do three cells (D10, E10, F10) ??? 

• Moved by Lanlan HuangMicrosoft contingent staff 6 hours 4 minutes ago

Hi

Try this : =IF(COUNT(D10:F10=""),"",SUM(D10:F10))

If this post is helpful or answers the question, please mark it so, thank you

Hi Terian,

According to your description, this issue is related to formula in excel, the Excel IT Pro Discussions forum is a better place for non-programing issue, and we will move it there for you.

Regards

Starain