View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default Needs to Show blank please

Hello from Steved

The below formula showing a 0 value, how do I show to be Blank Please.

{=SUM(IF('From Charters'!$A$1:$A$900="Orewa",IF('From
Charters'!$B$1:$B$900="Period.1",'From Charters'!$D$1:$D$900,0),0))}

Thankyou.