Changing Cell Data

[JTL9161]

Not sure if this is doable.

I have a spreadsheet approximately 200 rows with 12 columns for weeks in a quarter. Each column has a (projected) number that could be between 0 and 99 (usually not that high though) Those numbers go through each column and then I do a sum in the last column. Weekly though I need to go in and change the numbers to actual numbers thus changing my sum in the last column. Is there a way (I guess in another column) that will retain the projected number sum and then in another column give the actual number sum. Meaning columns A- L have 1 to 12 and column 13 has 78. Then the next time I go in I change the 1 to 5 which would change my total to 82 but I want to retain the 78 total so I can see the difference between projected sum and actual sum.

Hope I explained this well enough

Thanks,
James

 

[Scott T]

You would need to hard code your projected sum into another column. You could do this by using copy past special as values. Then your sum would be the actuals once you update the numbers and the other columns would be your original projected sum

 

[JTL9161]

Thanks.