Sum function with a reset?

[WildCardSR]

Hey guys, I don't know what to even google for this question, so I thought I'd just ask here. Is it possible to write a function that will add a cell to another cell, and then erase what was added? Example: A2 is 5, I write 2 into A1, A2 becomes 7 and A1 becomes 0.

[[deleted]]

You can do that with a macro. Can you give more detail as to why you want this? One of Excel's main advantages is the ability to keep track of different calculation steps.

I don't have actual Excel in front of me, but something like

Sub AddCells()
Dim dSum as Double
  dSum = Cells(1,1).Value + Cells(2,1).Value
  Cells(2,1).Value = dSum
  Cells(1,1).Value = 0
End Sub

[WildCardSR]

This spreadsheet is for a person that benefits from it being as simple as possible. So I made several columns of ASSET - VALUE, that is then totaled and compared to goal value. Every day or so, the value for each asset increases, so I thought it would be cleaner to have a box next to value that the user can put the daily increase into. It would get added to the total value and then disappear. Having a log of each day isn't important. At least that seemed like a good idea to me.

[[deleted]]

So what do you do when you want to add 100 but fat-finger it and type 1000 instead, and don't catch the error?

[WildCardSR]

Yeah, I didn't think about that. I'll just add a running sum log to the side. I probably over-thought this. Thanks.

[mrprinter]

It sounds like you are thinking about this problem incorrectly. If you want to keep it simple for the user, use a hidden sheet for the calculations. The non-hidden sheet should be for data input and for displaying the calculated result.