Hi, I'm struggling to find the right formula to add up the sales from a certain week number (variable by row) until week 52
Assume sum of weeks = D2, I've manually summed the weeks from and to (in this example up to week 10), however I have over 600 rows of data that differ by row.
I hope I've requested correctly and apolgoies if not.
<colgroup><col><col span="3"><col><col span="10"></colgroup><tbody>
</tbody>
Assume sum of weeks = D2, I've manually summed the weeks from and to (in this example up to week 10), however I have over 600 rows of data that differ by row.
I hope I've requested correctly and apolgoies if not.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||||
Completion Date | Week Number From | To | Sum of Weeks | Store Name | 06-Jan | 13-Jan | 20-Jan | 27-Jan | 03-Feb | 10-Feb | 17-Feb | 24-Feb | 03-Mar | 10-Mar |
13/01/2018 | 2 | 10 | 1,684 | Store A | 78 | 86 | 76 | 210 | 219 | 315 | 89 | 52 | 480 | 157 |
10/03/2018 | 10 | 10 | 497 | Store B | 332 | 383 | 401 | 299 | 152 | 355 | 224 | 234 | 156 | 497 |
03/02/2018 | 5 | 10 | 1,853 | Store C | 64 | 59 | 69 | 356 | 330 | 258 | 398 | 164 | 227 | 476 |
18/02/2018 | 8 | 10 | 812 | Store D | 170 | 115 | 142 | 162 | 145 | 93 | 124 | 364 | 176 | 272 |
<colgroup><col><col span="3"><col><col span="10"></colgroup><tbody>
</tbody>