Using Excel 2003 on XP.

I am trying to get a result based on values in 3 columns. Column J contains various dates, Column K contains various Employee group codes, Column T contains various card type codes.

I have only recently begun using the SUMPRODUCT function and am still trying to learn this (thanks to rylo for the introduction) but the latest formula I have constructed is giving me a #VALUE! error and I can't see what I'm doing wrong. I have Googled a number of sites (including this one) for information on using SUMPRODUCT but am still unable to see my error.

I have named the ranges I am using. The formula is:
=SUMPRODUCT(--(Org_End=DATEVALUE("31/12/9999")),--(EEGrp={"0","1","2","3","7","8"}),--(CType<>{"1","2"}))
The named ranges are:
Org_End: =Sheet1!$J$1:$J$886
EEGrp: =Sheet1!$K$1:$K$886
CType: =Sheet1!$T$1:$T$886

What I am trying to get is:
If column J contains the date 31/12/9999, AND column K contains the Employee group codes of 0, 1, 2, 3, 7, or 8, AND Column T contains any card type OTHER THAN 1 or 2, I need a positive result.

I have used the "Trace Error" tool and it points me to the top cell in each range i.e. J1, K1, and T1.

Am I incorrectly using the double unary? Is SUMPRODUCT the best function for this scenario or should I be using something else?

Any assistance showing where I am going wrong would be greatly appreciated.