Share via

TRICKY EXCEL PROBLEM!

Anonymous
2024-12-14T02:53:19+00:00

Is there a way to have a cell in excel keep adding from other cells that have been deleted.

I'm building a monthly account register, and all the transactions will have to be deleted at the end of the month. My problem is one of these categories is and amount sent to savings. I need that cell keeping track of how much has been put into savings over the months. The problem is when I delete all the transactions the total will delete as well.

Is there a way to keep a running total in Excel even if the cells its adding from get deleted?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. riny 20,870 Reputation points Volunteer Moderator
    2024-12-14T06:07:28+00:00

    Why create a register, then delete entries from it and expect it to keep track of totals of the deleted entries? I would recommend that you keep all entries in the register and add a column that designates their status, eg. "sent to savings". Then you can use one of many functions within Excel to summarise the register by status.

    Was this answer helpful?

    0 comments