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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.