No need for double negatives when you use * operator, only when the two
arrays are set apart by comma as in
=SUMPRODUCT(--(B1:B4=DATE(2006,1,1)),--(C1:C4=A1))
See http://mcgimpsey.com/excel/formulae/doubleneg.html

wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Duke Carey" wrote in message
...
=SUMPRODUCT(--(B1:B4=DATE(2006,1,1))*--(C1:C4=A1))

!