conditional sum issue
 

Hi and Thanks in advance,

I am trying to perform a conditional sum using the range b2:e49 based on 3
conditions. I used the conditional sum wizard and it put out this code:

{=SUM(IF($E$3:$E$49="SEP06",IF($D$3:$D$49=9475.5,I F($B$3:$B$49="B",$C$3:$C$49,0),0),0))}

Everything looks like it should work fine, but it doesn't . . . what am I
doing wrong?