How to copy a conditional sum, but change the column

  • Thread starter Thread starter Stabilos
  • Start date Start date
S

Stabilos

I have used the conditional sum wizard to create a sum of a column for
period 1 based on certain criteria. I can copy this conditional sum to the
next column for period 2 using the same criteria, but of course it is working
out the sum based on period 1 column data. I tried to go into the fourmula
bar and change the column cell reference. This action deletes the {} at
front and back of the formula. When I type them in again. The function of
hte conditional sum formula is lost.

Is there a way to achieve what I am trying to do without having to use the
conditional sum wizard on every column?
 
As it is an array formula, Excel indicates this by means of the curly
braces { } around the formula when viewed in the formula bar. An array
formula must be committed using the key combination of CTRL-SHIFT-
ENTER (CSE) instead of the normal ENTER - do not type the curly braces
yourself.

So, once you have amended the formula, just use CSE to commit it
again.

Hope this helps.

Pete
 
Thanks for your help Pete. That works a treat.


Pete_UK said:
As it is an array formula, Excel indicates this by means of the curly
braces { } around the formula when viewed in the formula bar. An array
formula must be committed using the key combination of CTRL-SHIFT-
ENTER (CSE) instead of the normal ENTER - do not type the curly braces
yourself.

So, once you have amended the formula, just use CSE to commit it
again.

Hope this helps.

Pete
Click to expand...
 
Stabilos said:
I have used the conditional sum wizard to create a sum of a column for
period 1 based on certain criteria. I can copy this conditional sum to the
next column for period 2 using the same criteria, but of course it is working
out the sum based on period 1 column data. I tried to go into the fourmula
bar and change the column cell reference. This action deletes the {} at
front and back of the formula. When I type them in again. The function of
hte conditional sum formula is lost.

Is there a way to achieve what I am trying to do without having to use the
conditional sum wizard on every column?
Click to expand...
 
The {=formula} means the formula is an Array formula.

When editing use CTRL + SHIFT + ENTER instead of just ENTER


Gord Dibben MS Excel MVP
 

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 - variable criteria 5
Sum with multiple conditions and wildcard 2
Conditional Sum - dragging 7
conditional formula question with multiple criteria 2
Conditional sum - Two dimensional (advanced) 3
Conditional Sum with "contains" 3
Conditional Sum 1
Conditional Formatting and sum of cells 1

Back
Top