Sumif increase rows and colums when copied

[cmclux]

I am trying to sum a column and rows in sheet 1 (Movement per Month) when column D in sheet 1 matches column B in sheet 2. I have the formula below, I think, for the first column in sheet 2, it starts in row E2. Now I need to copy the formula to F2 and I want the range to increase with one column as well.

=SUMIF('Movement per month'!$D$2:$D$2000,VLOOKUP($A2,Movement_Month,4,FALSE),INDEX('Movement per month'!$L$2:$BE$252,0,COLUMNS($E$2:E2)))

 

[cmclux]

What I am trying to do is to copy the formula and then summing another column in addition to the first column. The columns are based on data and I need the cumulative total for each column. This is the formula for the first column:

SUMIF('Movement per month'!$D$2:$D$2000,VLOOKUP($A2,Movement_Month,4,FALSE),'Movement per month'!L$2:L301)

This is the formula for the second column:

SUMIF('Movement per month'!$D$2:$D$2000,VLOOKUP($A2,Movement_Month,4,FALSE),'Movement per month'!L$2:L301)+SUMIF('Movement per month'!$D$2:$D$2000,VLOOKUP($A2,Movement_Month,4,FALSE),'Movement per month'!M$2:M301)

It just adds the two SUMIFS. I can just keep copying and multiplying the formula but the data starts in 2009 which makes me wonder whether there is an easier way to do it?