Simple Tweak

[petiteshiraz]

I have the following formula adding the values of three cells:

=SUM(B9:D9)

How can I change this so that if all three cells are blank, then it leaves the field blank instead of putting a zero there?

 

[MrKowz]

Try:
=IF(COUNTIF(B9:D9,"=")=3,"",SUM(B9:D9))

 

[petiteshiraz]

THANKS! That works great!

 

[MrKowz]

THANKS! That works great!

Glad it works, thank you for the feedback.