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?
=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?