I need a Formula for this situation.




My Sheet is setup with these Columns - C for "DEL" & D for "ADD" and G for Count.


Lets Say, Column G starts with a Number (1000) in G1

If the 2nd Row Cell is C2 = DEL(-1), G2 in this Row needs to be G1 in the Row above, minus 1, making the New Count at G2, 1 less than the G1 in Row above G2 = 999.

If the 3rd Row has D3 = ADD (+1), G3 in this Row needs to be G2 in the Row above, plus 1, making the New Count G3 on this Row, 1 greater than G2 in the Row above.


C D G
1 1000
2 DEL 999
3 ADD 1000
So it goes on with the Col G changing, Up or Down, based on the Value in Cols C & D.
Can you please provide ma a Formula to achieve and that will Copy forwards in Col C.
I hope you can follow what I am doing to remove the Human Error in Adding or Subtracting in Col G.

Thank You