E elhann0n Estimable Mar 4, 2014 1 0 4,510 Mar 4, 2014 #1 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.
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.
A Alabalcho Judicious Jan 13, 2011 4,162 4 35,260 Mar 4, 2014 #2 Check "Recalculation" options, you might have turned them off. Upvote 0 Downvote