# Cell Sum Total based on cells in CURRENT week column

#### tmcnelley

##### New Member
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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Replies
3
Views
559
Replies
9
Views
260
Replies
1
Views
233
Replies
18
Views
793
Replies
3
Views
238

1,221,127
Messages
6,158,101
Members
451,464
Latest member
Holden3

### 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.

### Which adblocker are you using?

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

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