I am using Excel 97 & Excel XP.

I have a formula
=SUMPRODUCT((EA!$F$2:$F$20000="Apples")*(EA!$B$2:$ B$20000=28/11/2004)*(EA!$B$2:$B$20000<=4/12/2004))

but it is not giving me a result. I have also tried:

=SUMPRODUCT(-(EA!$F$2:$F$20000="Apples"),-(EA!$B$2:$B$20000=28/11/2004),--(EA!$B$2:$B$20000<=4/12/2004))

but that also fails, can someone tell me where I am going wrong, please as
with either of the two below, using only two criteria it works fine!

=SUMPRODUCT(--(EA!$F$2:$F$20000="Apples"),--(EA!$B$2:$B$20000=28/11/2004))

=SUMPRODUCT((EA!$F$2:$F$20000="Apples")*(EA!$B$2:$ B$20000=28/11/2004))

Mark