Sum formula that will stay constant when the data is deleted

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

What I am trying to do is have a cell that has a basic sum
function and the data coming from different cells and when
this data is erased, the sum function total will remain.
Basicall I have an input box that each person inputs the
number of items they receive throughout the day and I
would like this to be changed daily but the total from the
previous day remain in cell A1 for example. Thanks in
advance for the help.

Todd
 
There may be other methods, but i've solved this problem
with a macro. 1st put a date in the same row as your data
you want to keep. Then, create a macro with these steps:
(First add another worksheet)macro = insert a new row in
row1, goto your data source, copy row with summed data,
back to new worksheet, paste values.
This will keep a running history of you info
 
Back
Top