[RESOLVED] Selection in Excel

[artizan]

I have an Excel spreadsheet which has a field which contains both the name of the product and additional information about the product eg Zebra LP2824P 2" DT desktop printer, parallel with Dispenser (UK/EU)

I want to find out how many times in the spreadsheet the word "Zebra" appears. I have tried using the VB code:

=SUMPRODUCT(--(MONTH($B$2:$B$250)=7),--($D$2:$D$250="Zebra")) However this only finds the lines that only contains the word "Zebra" where there is nothing else in the cell.

Is there a way of selecting the word from the whole string?

Grateful for any help you can offer.

[anhn]

Firstly, why -- ?

Try this:
=SUMPRODUCT((MONTH($B$2:$B$250)=7)*NOT(ISERROR(FIND("Zebra",$D$2:$D$250))))

[artizan]

Thank you I will try this. The data comes from a SQL database which the administrator will not give me access to so I just get a dump each week which I have to pull the bones out of!!

Many thanks again