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.
<tbody>
</tbody>
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.
CUME TO WEEK | 10'000'000 | 8'000'000 |
WEEK 1 | 250000 | 150000 |
WEEK 2 | 300000 | 280000 |
WEEK 3 | 400000 | 350000 |
<tbody>
</tbody>
Example above if this helps
Thanks
Drew