On Nov 25, 11:05*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
In cell b14 this is my formula - if these cells are blank i want the return
to be blank it is giving me a return of 0
=if(sum(b4:B13),"",sum(b4:B13))

--
Message posted viahttp://www.officekb.com

This formula won't work as the if statement is not entirely correct.

If Sum(b4:B13) then
Null
Else
Sum(B4:B13)
End If

There's nothing to compare it against in the If clause..... it should
be something like

If Sum(B4:B13) = 0 Then
Null
Else
Sum(B4:B13)
End If

or

=IF(sum(b4:b13)=0,"",Sum(B4:B13))

or.... use custom number formats.....

Why not use a custom number format on the cell.
Something along the lines of this.... _-* #,##0_-;-* #,##0_-;_-* ""??
_-;_-@_-

Format Cells Custom


If you want decimal places then it would look like.....


_-* #,##0.00_-;-* #,##0.00_-;_-* ""??_-;_-@_-


If you want a dash (using the decimal places)


_-* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_-


Try that.