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,IF($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?
Bookmarks