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.

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