Just be aware that just because you don't see a zero in that cell there is
one!

So, if say, you wanted to then average values in a range that carried that
format, the unseen zeros could cause a problem!

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> 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.
>>