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.
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.
Just remove the #N/A in the F2 CEll and it will work
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.
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++)
Nice catch jungix
debauch don't forget to mark your thread solved please
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln