Addition without overwriting the previous value

New Contributor
Dear Community,

I am looking for a code or formula with which I have a result cell and a value from another cell is always added.

So as an example:

A is the target cell and currently still has the value "0".
If I now enter in cell B - 5 this should be added and if I enter again there 5 should total
10 should come out in cell A
so that the previous value is not overwritten, but always only added to it.

I have already tried some things. Hope someone can help me here?

Best regards:
2 Replies
best response confirmed by _jannick99_ (New Contributor)


In the attached file you can enter a number in cell B1 which is then added to the value in A1. This might be what you are looking for.

That's it! Thank you very much! My savior!