pomegranate-man wrote:
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.")


"another poster" = same poster

I had the same thoughts when I re-read the OP's request..."if B5:D5 is empty" is
different than "if B5:D5 equals zero".