View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Steve. :)

=if(sum(B389:B413)=0,"",sum(B389:B413))
*******************
~Anne Troy

www.OfficeArticles.com


"Steved" wrote in message
...
Hello from Steved

Using the below what would I need to do to have the cell blank as at the
moment it is showing a 0 value

=SUM(B389:B413)

Thankyou.