hi
in addition to Bob to check for all combinations of L5-T including
spaces try using SUBSTITUE
=SUMPRODUCT(((NOT(ISERROR(FIND("L5-T",SUBSTITUE(TIR,"
","")))))*(Dates=20030628)*(Dates<=20040107)*(CLA SS=C4)*(SUBSYSTEM=IND
IRECT(B5)))

Frank

Bob Phillips wrote:
ED,

If it is the L5-T, you could always use OR, like this

=SUMPRODUCT(((NOT(ISERROR(FIND("L5-T",TIR))))+(NOT(ISERROR(FIND("L

5-T",TIR))))*(Dates=20030628)*(Dates<=20040107)*(CL ASS=C4)*(SUBSYSTEM=
INDIR
ECT(B5)))

I haven't tested this, and it gets more complex if you could have L
5-T, L5-T, L5 -T, etc., but give it a try

And anyway, have you learnt anything, because that is important?


"Ed" wrote in message
...
I feel stupid, Bob! I was playing with it and took it down to just
the two references to cell values:
=SUMPRODUCT((CLASS=$H$4)*(SUBSYSTEM=$B5))
This works fine! I guess what that means is that when I'm calling
another criteria, it's not exactly the same in every cell (ie:
"L5-T" might also be "L 5-T"). Now I've got to find a way to scan
every entry and validate
it -
or maybe give up and do this manually (filter, count rows, repeat).

I'll keep playing and see what happens. Thank you for your
continued
interest and help.
Ed