=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?
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?