Forum Discussion
Solved
Addition without overwriting the previous value
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:
Jannick
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:
Jannick
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.
2 Replies
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!
