I have a large (over 500 row) spreadsheet for tabulating simple data. The Sum
function has suddenly stopped working when I copy and paste it to a new
location. Instead of delivering the sum of the range in the pasted location
it delivers the number from the location it is copied, ignoring the data in
the range it is supposed to add up.