HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV.
 

I want to set up a set of conditional sums.
Rather than use the wizard each time, I'd like to copy the formula, and edit
the condition.
I know there is a combination of keys to press to then make the edited
formula work (shift + something+enter)?

after pasting to the target cell, press F2 to enter the edit mode.


--
nbrcrunch

Thanks, I can get into edit mode ok, but after editing, the new formula does
not then work. I know there is some key combination that you can use to make
an edited formula work - does anyone know this please?

"nbrcrunch" wrote:


after pasting to the target cell, press F2 to enter the edit mode.


--
nbrcrunch

Thanks, I can get into edit mode OK, but after editing, the new formula does
not work. I know that there is a combination of keys that will make this
work,does anyone know what this is ?

"nbrcrunch" wrote:


after pasting to the target cell, press F2 to enter the edit mode.


--
nbrcrunch

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

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