TGalin wrote:
How can I change this formula =SUM(B5:D5) so that it will return a
blank cell instead of a zero if B5:D5 is empty?

=IF(your_formula=0,"",your_formula)

If the range might include positive/negative/zero numbers that actually sum
to zero, a zero result would be more informative than an empty-string
result. Another poster suggested a different formula that does this:
=IF(COUNT(B5:D5)=0,"",SUM(B5:D5))

(I know, "picky, picky.")