Dragging formula down while increasing only 1 criteria

[Princeper]

Hi, I have this simple formula:

=SUMIF(Transacties!T:T, "=7", Transacties!S:S)

It seems impossible to drag it around. When I wanna drag to the right, the "=7" stay the same, but the increments in T and S are not good ( I need steps of 5)
When I drag it down, I cant make it to increase only the 7 to an 8, then a 9, then a 10 etc.

Is there any solution to make it and increase by 1 when dragged down? Its a lot of work by hand

 

[Osvaldo Palmeiro]

Hi.
Try:

=SUMIF(Transacties!$T:$T, "="&ROW(A7), Transacties!$S:$S)

or just

=SUMIF(Transacties!$T:$T,ROW(A7), Transacties!$S:$S)

 

[Princeper]

This works for me, I used the second one.

 

[Fluff]

As you have xl 2021 you could also use

=SUMIF(Transacties!T:T,SEQUENCE(4,,7),Transacties!S:S)

& it will automatically spill down just change the 4 to however many criteria you have