I like it too, but I have to keep referring to the help file to make
sure I've got it right.

In article <[email protected]>,
"Biff" <[email protected]> wrote:

> Nice!
>
> I don't think I've ever seen that one!
>
> That's going into my stash.
>
> Biff
>
> "Domenic" <[email protected]> wrote in message
> news:[email protected]...
> > 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.