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