Year to date to week - Index Match & Sum Ifs function?

[Jonas0]

Hello Everyone!

I struggled with setting up a formula, that shows the sum of the year to date numbers of the past and current month.
In the current month it should be possible to differentiate until which week the sum should be drawn.
My guts tell me that a combination of a Index Match function and Sum if function could be the solution, but I could not find the right way..

To make the situation a bit clearer:

Country	Week 1	Week 2	Week 3
China

<tbody>
</tbody>

Country	Week	Jan	Feb	Mar
China	Week 1	1000	2000	400
China	Week 2	400	750	700
China	Week 3	1200	3000	2100
China	Week 4	800	1200	300

<tbody>
</tbody>

Assuming that it is the 2. week of February, below 'Week 2' in the first table the sum of January and Week 1 & 2 of February should be displayed.

Does anyone have an idea?

I'd be very grateful for any advice.

 

[Jonas0]

I forgot to mention: The second table is the 'data base' and the first table is the 'out put table'