Sum formula that will stay constant when the data is deleted

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
 
W

warnimont

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
 
Top