Wild Card in SUMPRODUCT formula search

[Bravo2003]

=SUMPRODUCT(--('2019 Sales'!$CR$1:$CR$1055<>"IND")*--('2019 Sales'!$D$1:$D$1055=$A$2)*--('2019 Sales'!$B$16:$BY$16=BX$1)*--('2019 Sales'!$B$17:$BY$17=$A3),'2019 Sales'!$B$1:$BY$1055)

Using the above SUMPRODUCT formula - where I have "IND"
aim is to sum everything excluding any matches to IND, but I have IND-xx (various xx references - eg IND-JC, etc)

I tried using the WildCard * - <>"IND*"
But this doesn't exclude anything.

Am i using the right format? or is there any way to ask for a wild card search?

Or will I have to revert to adding a new column along side the IND-* column to remove the suffixes?

 

[njimack]

=SUMPRODUCT(--(ISERROR(SEARCH("IND",'2019 Sales'!$CR$1:$CR$1055))),--....

 

[Bravo2003]

=SUMPRODUCT(--(ISERROR(SEARCH("IND",'2019 Sales'!$CR$1:$CR$1055))),--....

Excellent, Thanks