Maybe try changing this part of it in your expression to:

... *(ISERROR(SEARCH("shine*",'grid
data'!D2:D4557))*(ISERROR(SEARCH("non*",'grid data'!E2:E4557))* ...

.. Promise this will be the last question.
No need for such promises. You could always put in any new queries as fresh
new postings, which is the usual route to take once the original query is
answered, and the thread closed. I may not always be around or be able to
help, but there are **many** other responders out there who would be in a
position to do so and who enjoy doing so. Putting in as new postings would
immediately surface your new query to their ever-attentive radar.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<paultedder wrote
Promise this will be the last question. You've given me some ideas and
I'm going crazy with alternate options.

On the following formula I am not getting the right results. It
appears to be ignoring the search for "NON" in column E.

=SUMPRODUCT((('Grid data'!B2:B4557=A2)*(ISERROR(SEARCH("shine*",'Grid
data'!D2:D4557)+(SEARCH( "non*",'Grid data'!E2:E4557))*((('Grid data'!
F2:F4557="NS")+('Grid data'!F2:F4557="C")+(TRIM('Grid data'!
F2:F4557)="")))))))

With your expert eye, can you see the issue as I'm wearing my nails
down trying to see it

Paul