Hello All
I am very new to Excel and this may be a silly question, but I want to create an accumulator in a cell (ex. D4) that adds to itself from input from another cell (ex. A1). So, when A1=10, D4=10. Then A1 =15, D4=25. A1=3, D4=28. I also want this value to remain in the workbook after saving and closing. I will have two of these for two different values that are not related, but accept input from the same source cell. To complicate matters, I want one of these accumulators to accept negative numbers, but not the other. I believe this can be solved with a simple If statement using < 0 to hedge out anything negative form that specific accumulator. Any help would be greatly appreciated. Thanks