SUM formulas

Copper Contributor

Hello! 🙂 I want to create a excel doc to manage my monthly budget. Until now I used the simple SUM formula, but I had to do the maths for all the numbers that I added to a cell.  I was thinking of adding a number in a empty cell, the cell empties after, and that number is automatically added(sumed) to another cell. For example, if I write "10" in a cell, it empties, and it's added to another cell. And if I write "20" after the first operation, it empties again and it's added to the other cell, which now displays the number "30". Is there a formula or equation for this type of criteria? Thank you 🙂

2 Replies
Can you elaborate or share the file or some screenshot of the problem ? You can also DM me

@ivanovleonardsebastian 

I wouldn't recommend doing this. You'd have no way to check the correctness of the cell with the total, and correcting mistakes would be difficult.

Using separate cells and SUM is much better.