Try it this way:

=SUMPRODUCT((D1:D999=--"1/1/2008")*(D1:D999<=--"31/12/2008")*(G1:G999="apples"))

or like this:

=SUMPRODUCT((D1:D999=DATE(2008,1,1))*(D1:D999<=DA TE(2008,12,31))*(G1:G999="apples"))

Hope this helps.

Pete

On Jul 29, 2:18*pm, Stevo wrote:
Hi,

I have a long list of records all on the same worksheet. *In column d are
the categories I want to search on (e.g. apples). *I am tryoing to found out
how many apples between 01/01/2008 and 31/01/2008. *I have tried

=SUMPRODUCT((D1:D999)=1/1/2008)*((D1:D999)<=31/12/2008)*(G1:G999="apples")

This returns 0 even though there are apples in column g between these dates. *

Can somebody please help?

Best regards

Steve