Sumif increase rows and colums when copied

cmclux

New Member
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)))

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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?

Replies
20
Views
921
Replies
6
Views
273
Replies
7
Views
161
Replies
19
Views
199
Replies
1
Views
431

1,206,921
Messages
6,075,581
Members
446,147
Latest member
homedecortips

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back