I think I may have found a problem

[cganivet]

Hi,

Please refer to my involvement in the following thread titled "SUMPRODUCT with >< as criteria":

http://www.mrexcel.com/forum/showthread.php?t=316588&goto=newpost

In the last few of my responses to crazyleg I have attempted to paste in a nested SUMPRODUCT command. It has 4 nested IFs and yet when the message is posted the 3 "inside" nested IFs are missing. This leaves only the "outside" IF statement. This happens even if I try to specify the command as code.

I have pasted the command again below. You should see "IF(" 4 times. If not, the problem has occurred here also.

=IF(G3="<",SUMPRODUCT(($C$3:$C$63682<H3)*($E$3:$E$63682=G35)), IF(G3="<=",SUMPRODUCT(($C$3:$C$63682<=H3)*($E$3:$E$63682=G35)), IF(G3="=",SUMPRODUCT(($C$3:$C$63682=H3)*($E$3:$E$63682=G35)), IF(G3=">=",SUMPRODUCT(($C$3:$C$63682>=H3)*($E$3:$E$63682=G35)), SUMPRODUCT(($C$3:$C$63682>H3)*($E$3:$E$63682=G35)) ))))

I think this might be a bug?

Cheers.