View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Cell to return blank not 0

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