formula not working

[kylefoley76]

=SUMPRODUCT($I$2:$I$3000,--($G$2:$G$3000=N$1),--($D$2:$D$3000=$K3))

I can't see what's wrong with the above formula. It's returning #n/a and it was working just fine a moment ago.

 

[MrKowz]

Does any of your ranges contain an #N/A! error?

 

[kylefoley76]

yes, they do. I got rid of them, that solved it, thanks for the help.