Limiting value in cell and adding remainder in another cell

Thank you both so much!

Marvin, that is very close to what I need. How would I add another range to the result you have in B1? For instance whatever my balance is in B1, say I want to add A20:A25 to that?

Thanks!