View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Remove Zero Formula

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?



Or, maybe this:

=IF(COUNT(B5:D5)=0,"",SUM(B5:D5))