| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying "total" rules in Excel from one cell to another
Can anyone help on this problem with Excel I have encountered?
I put figures in a column with a auto sum total at the bottom. I then copy the total rule from the bottom of column A into a cell in column B. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying "total" rules in Excel from one cell to another
ToolsOptionsCalculation.
Ensure "automatic" is checkmarked. OR the formula you copied has absolute references like =SUM($A$1:$A$23) If so, remove at least the $ from the column refs. =SUM(A$1:A$23) BTW..........it is commomly known as a "formula" not a rule. Gord Dibben MS Excel MVP On Wed, 30 May 2007 18:16:01 -0700, JamieMairata wrote: Can anyone help on this problem with Excel I have encountered? I put figures in a column with a auto sum total at the bottom. I then copy the total rule from the bottom of column A into a cell in column B. The value of the total in Column B now shows the same value as the total in column A, even though the "rule" clearly shows it will add the contents of column B?! Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Find all cells with "A" and add the values of the adjacent cell to give a total. | Excel Programming | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Search "Total" in all worksheets and delete rows containing "Total" | Excel Programming | |||
Hybrid Mode
