I have found what I was looking for!
After editing the copied conditional sum press - Ctrl + Shift + Enter. This
makes the sum work with the edited condition rather than the condition before
the copy. Thanks to all who helped me on this.

"nbrcrunch" wrote:


I must admit that i am not aware of any special key sequence.

I am wondering if the formula you are using is an Array. Does the
original formula have cruley brackets in it? If so, after editing the
array, you need to press Ctrl-Shift-Enter.

If this is not the issue, then you are not completely or correctly
editing the formula.


--
nbrcrunch