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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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?
 
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 ?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum Wizard 4
Sum of squares if condition 4
how do I sum currency values in a row containing currency and uni. 2
How can I replicate a conditional sum formula? 2
SumIf AND 6
Conditional sum 1
Can I have two conditions in a SUMIF? 5
SUMPRODUCT sum until condition changes 1

Back
Top