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

--
Jamie Mairata

Tools>Options>Calculation.

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
<(E-Mail Removed)> 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