What do you mean by "these cells" -- all cells in the range b4:b13? If so,
try:
=if(count(b4:b13)0,sum(b4:b13),"")
Regards,
Fred.
"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:8db1c7edb6a62@uwe...
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 via http://www.officekb.com