Newbie with text problem

[Mr Ned]

Hello,

I have a workbook which calculates the salesfigures from the team and in the summary page it all totals correctly. I am using the sumproduct function to do this.

As I now have to exclude certain rows where the vendor code begins with "DS ALC". I would like to do this directly on the data sheet, and I would like to do this by reviewing the date field and placing a "0" in a new cell where the vendor code is as above.

I thought I might be able to use an "if" statement

sorry if I am vauge

 

[sheetspread]

=if(a1= "ds alc",0,"")

 

[Mr Ned]

Thanks that will give me the value if the text is an exact match, but I have other vender codes that start with DS ALC -1 and so on, so do i need to use LEFT or RIGHT

 

[sheetspread]

=if(iserror(find("ds alc",a1,1))=false,0,"")