Conditional Sum Wizard editing question

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

My formula from the CSW when all is said and done is
surrounded by { } 's. These go away and the formula craps
out if I try and edit it.

Is there a way I can edit or change a cell reference in
the forumla while still keeping it intact? I do not
understand what I am doing wrong.

Example formula: {=SUM(IF(Jobs!$C$2:$C$164=O84,IF(Jobs!
$K$2:$K$164>=C85,IF(Jobs!$K$2:$K$164<=E85,Jobs!
$F$2:$F$164,0),0),0))}

I need to change the O84 to P84, but if I edit the
formula I lose the {} and the formula no longer works.

Any advice is greatly appreciated, thanks,
Chris
 
The { } brackets are put there by Excel. That means the formula is arra
entered (CTRL + SHIFT + ENTER or CSE). So, when you edit a cell, the
instead of using ENTER, hit the CSE combination.
 
Back
Top