| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a conditional sum, but change the column
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy a conditional sum, but change the 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 On Apr 11, 10:27*pm, Stabilos wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy a conditional sum, but change the column
Thanks for your help Pete. That works a treat.
"Pete_UK" wrote: 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 On Apr 11, 10:27 pm, Stabilos wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy a conditional sum, but change the column
Glad to hear it - thanks for feeding back.
Pete On Apr 11, 10:52*pm, Stabilos wrote: Thanks for your help Pete. *That works a treat. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy a conditional sum, but change the column
"Stabilos" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy a conditional sum, but change the column
The {=formula} means the formula is an Array formula.
When editing use CTRL + SHIFT + ENTER instead of just ENTER Gord Dibben MS Excel MVP On Tue, 5 Aug 2008 10:13:01 -0700, maharana.santnu wrote: "Stabilos" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional change of column reference in formulas | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Conditional formatting -- copy paste special won't change referenc | Excel Discussion (Misc queries) | |||
| copy a formula that does not change the column or row number? | Excel Discussion (Misc queries) | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Linear Mode
