horkstar12
New Member
- Joined
- May 16, 2016
- Messages
- 9
Hello,
I have a table of data, in the first column is the week i.e Week 1, Week 2 etc. In the second column i have fully populated with last year sales data by week. in the final column i have this year data which every Monday is updated.
I have this setup for many departments and each week i have to go through each sheet and amend the CUME week to date sum.
For example we are currently on week 20 so i go into the cume SUM forumla for both last year and this year and move this down one to include week 20.
Ideally i want a formula to look at the THIS YEAR column and when this becomes populated to SUM from week 1 to that week. Formula will then be applied to the Last year and this year cume figures.
[TABLE="width: 500"]
<tbody>[TR]
[TD]CUME TO WEEK[/TD]
[TD]10'000'000[/TD]
[TD]8'000'000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEEK 1[/TD]
[TD]250000[/TD]
[TD]150000[/TD]
[/TR]
[TR]
[TD]WEEK 2[/TD]
[TD]300000[/TD]
[TD]280000[/TD]
[/TR]
[TR]
[TD]WEEK 3[/TD]
[TD]400000[/TD]
[TD]350000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example above if this helps
Thanks
Drew
I have a table of data, in the first column is the week i.e Week 1, Week 2 etc. In the second column i have fully populated with last year sales data by week. in the final column i have this year data which every Monday is updated.
I have this setup for many departments and each week i have to go through each sheet and amend the CUME week to date sum.
For example we are currently on week 20 so i go into the cume SUM forumla for both last year and this year and move this down one to include week 20.
Ideally i want a formula to look at the THIS YEAR column and when this becomes populated to SUM from week 1 to that week. Formula will then be applied to the Last year and this year cume figures.
[TABLE="width: 500"]
<tbody>[TR]
[TD]CUME TO WEEK[/TD]
[TD]10'000'000[/TD]
[TD]8'000'000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEEK 1[/TD]
[TD]250000[/TD]
[TD]150000[/TD]
[/TR]
[TR]
[TD]WEEK 2[/TD]
[TD]300000[/TD]
[TD]280000[/TD]
[/TR]
[TR]
[TD]WEEK 3[/TD]
[TD]400000[/TD]
[TD]350000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example above if this helps
Thanks
Drew