PDA

View Full Version : SumProduct Error



debauch
07-21-2006, 12:24 PM
Can anyone help determine why I would get the #N/A in this SumProduct error? I have spent 1/2 the afternoon messing around with this.

jungix
07-21-2006, 12:29 PM
Just remove the #N/A in the F2 CEll and it will work

debauch
07-21-2006, 12:39 PM
Lol, Oh my....I was fixing this for someone, and they always color their text, so they do not lose the formula. My mistake => How silly.

jungix
07-21-2006, 12:43 PM
It's often silly. I was once blocked one whole day in Java because I did not see an infinite loop:

for (i=0;i<100;i++)
for (j=0;i<100;j++)

lucas
07-21-2006, 12:46 PM
Nice catch jungix
debauch don't forget to mark your thread solved please