Hlookup a week number and sum from that point until week 52

[Katsimps]

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.

					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>

 

[szita2000]

Hi.

Welcome to the forum.

Try to put this in to Cell P3 then drag it down

=IF($C3=$B3,OFFSET($F3,0,C$3-1),SUM(OFFSET($F3,0,$B3-1,1,($C3-$B3)+1)))

If it works you can add it in to Sum of Weeks column.

 

[Katsimps]

Hi.

Welcome to the forum.

Try to put this in to Cell P3 then drag it down

=IF($C3=$B3,OFFSET($F3,0,C$3-1),SUM(OFFSET($F3,0,$B3-1,1,($C3-$B3)+1)))

If it works you can add it in to Sum of Weeks column.

Thank you so much, this works!

 

[Katsimps]

Thank you so much, this works!

 

[szita2000]

You welcome.