Hello Domenic from Steved

Domenic thankyou, Thius is a much better solution because you have a much
clearner formula.

Great Stuff

Thanks again for your thoughtfulness.

"Domenic" wrote:

> You can also custom format your cell...
>
> Format > Cells > Number > Custom > Type: 0;-0;;@
>
> Hope this helps!
>
> In article <[email protected]>,
> Steved <[email protected]> wrote:
>
> > Hello from Steved
> >
> > If no Data the cell is returning a 0 value I need it in this case to be
> > blank please.
> >
> > SUM(IF('From Charters'!$A$1:$A$900="Roskill",IF('From
> > Charters'!$B$1:$B$900="Period.1",'From Charters'!$D$1:$D$900,0),0))
> >
> > Thankyou.
>