What is wrong with my formula?

=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) ??? 

July 16th, 2015 10:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics