Copying "total" rules in Excel from one cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top