A2 Contains value1 say 10 for example B2 contains Value2 also 10 C2=A2+B2
A2
10
B2
10
C2
20
I need to clear the values in A2 and B2 but keep the answer in C2 and transfer it to C3
Next day new values are entered in A2 & B2 answer is in C2
C4=C2+C3
This is a simple example of a much larger project the problem I am having is when you clear the values in A2 and B2 the answer obviously has to be zero.
Anyone know of a way to do this maybe with variables?
Thanks
Charles
Bookmarks