I need help with a basic IF 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) ???

Thanks in advance for your reply

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

i.e all ceils D,E,F are blank or 0

=if(sum(d10:f10)=0,"",sum(d10:f10))

WOW, I love this time zone difference. Getting help from the a wonderful guy in the UK. John Topley and Seassider89 you both are a life saver. It work, but placed "VALUE" in my Subtotal. But, I followed your formula and keyed in the correct cell and it worked too! Praise and much love from the southern state of Georgia in the USA.