problem with sumproduct formula

[y481184]

Can someone please tell me why this formula is not working?

=SUMPRODUCT((Query!$D$11:$D$1502 = "10")*(Query!$K$11:$K$1502 = "13")*(Query!$J$11:$J$1502))/2000

I am not receiving an error, I am simply not getting any value at all, even though there are cells in D11:D1502 that do equal 10 and cells in k11:k1502 that equal 13. Why is there a problem?

 

[fairwinds]

Hi,

Take away the double quotes around 10 an 13.

 

[y481184]

Thank you so much. Can you answer one more question for me? How could I incorporate dates into this sumproduct formula. For instance I would like to add only sum records in which:

D11:D1502 = 10
K11:K1502 = 13
and C11:C1502 is between 5/5/2003 and 7/10/2003

Is there anyway that this can be done? I tried to insert a DATE function within my SUMPRODUCT function, but this did not work. Any suggestions?

 

[fairwinds]

=SUMPRODUCT((Query!$D$11:$D$1502=10)*(Query!$K$11:$K$1502=13)*(Query!$C$11:$C$1502>=DATE(2003,5,5))*(Query!$C$11:$C$1502<=DATE(2003,10,7))*(Query!$J$11:$J$1502))/2000