Increase column reference when copied down

[ihaveanexcelquestion]

I have a sumifs function where I would like to increase the criteria range by one letter when copied down. The formula reads as follows:

=SUMIFS(A:A, D:D, 1)

In the cell directly below it when copied down, I would like the formula to act as though the column reference to D:D increased to E:E, but allow all else to remain the same.

 

[hrayani]

try

=SUMIFS(A:A,OFFSET(D:D,0,ROW(1:1)*1-1),1)

 

[Fluff]

Another option

=SUMIFS(A:A, INDEX(D:Z,,ROWS(AA$2:AA2)), 1)

Change the AA$2:AA2 part to reflect the cell the formula is first entered in.