If what you want to do is prevent the sum from going negative
by adding to A1, you can do this:
Select the negative sum.
Tools Goal Seek
To Value: 0
By changing cell: A1