Jan 11 2024 03:20 AM
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 🙂
Jan 11 2024 06:03 AM
Jan 11 2024 06:33 AM
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.