Strange behavior when copying formula.

  • Thread starter Thread starter Leo Leong
  • Start date Start date
L

Leo Leong

Hi,

Here is what I'm trying to do. I want to show the summation of the first
two rows' number in the third row. I use the summation function to get the
first result. Then, I copy and paste the result to the other two, but they
show the same results as the first one. I check the formula of all three
results, and they are all correct and referring to the right cells. Why is
that?

1 2 3
1 2 3
2 2 2

Leo
 
Do you have Tools/Options/Calculation set to Manual?

If so, click the Automatic button.
 
Back
Top