Cell Sum Total based on cells in CURRENT week column

tmcnelley

New Member
Joined
Jan 22, 2019
Messages
1
First time poster...tried to search for this answer with many different search keywords and came up empty or more confused...

I have a financial spreadsheet with a fixed (frozen) column on left side of spreadsheet that has cells to track some financial goals and my current status toward completing the goal.
Finances are tracked weekly with Thursday being the 'first day of week' and the spreadsheet moves to the right of the fixed column as the weeks progress.
So if I have a 1,500.00 savings goal and the current week's savings goal has 975.00 summed/totaled from 3 different cells, I want to see 975.00 in the fixed cell/column on left side of spreadsheet.
When the week rolls into the 'next' current week and a new set of columns, I want the fixed cell to show the new savings total based on the 'next' current week cells, assuming that each week money is added to savings accounts and updated in that week's cells that track savings.

So.....how do I change my fixed cell (A12 in screenshot) references to look at 3 cells in the same 'weekly' column (D6:D9 as an example)...and that fixed cell showing my up to date savings total would then update based on the 'next week' savings total (G6:G9 as an example)

Screenshot Explanation:
Relevant cells to the problem is provided in screenshot
At left is the fixed column showing Savings Goal of 1500.00 and Current Amount of 975.00 as of week 3, 1/17/2019. That Current Amount cell is summing the cells D6:D9
At top is a cell showing weekly savings increases of 50.00.
In the middle area you will see 3 Savings accounts with the dollar amount in each account in each cell.
On 1/24/2019, another 50.00 is transferred into Savings 1 and you can see the cells in middle area reflect that new Savings total.
When 1/24/2019, or week 4 occurs, I'd like the Current cell on left side (A12) of screenshot to now look at cells G6:G9 for its new SUM....and then the same behavior should occur when the week 5, 1/31/2019 begins.

ABCDEFGHIJ
1Notes1/17/201931/24/201941/31/20195
2To Savings 1-$50.00To Savings 1-$50.00To Savings 1-$50.00
3
4
5Cash$0.00Cash$0.00Cash$0.00
6Savings 1$150.00Savings 1$200.00Savings 1$250.00
7Savings 2$650.00Savings 2$650.00Savings 2$650.00
8Savings 3$175.00Savings 3$175.00Savings 3$175.00
9Savings GoalEdward Jones$0.00Edward Jones$0.00Edward Jones$0.00
10$1,500.00Other$0.00Other$0.00Other$0.00
11Current:Total Assets$975.00Total Assets$1,025.00Total Assets$1,075.00
12$975.00
13

<tbody>
</tbody>
Personal Cash Flow (2)
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,125
Messages
5,768,259
Members
425,460
Latest member
Astros1243

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top