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

5)=0,"",SUM(B5

5))

(I know, "picky, picky.")