excel copy paste problem

Status
Not open for further replies.

elhann0n

Reputable
Mar 4, 2014
1
0
4,510
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.
 
Status
Not open for further replies.