excel copy paste problem

copying the formula sum(a1:a3) from a4 to b4 does show sum(b1:b3) in the b4 cell, but, value is still the same as a4. Changing a character (eg deleting and reentering the 3 in sum(b1:b3)) gets the correct value.
1 answer Last reply
More about excel copy paste problem
  1. Check "Recalculation" options, you might have turned them off.
Ask a new question

Read More

Formula Excel Apps