Change a sumif formula to be more dynamic

[CaptainGravyBum]

Hello,
I have a formula that is working very well, but it has a unique row number specified. If I try to drag it past the set number of rows the formula errors.
How can I make it more dynamic?, sorry for just pasting the formula, but hopefully you can get anything you need from it without the worksheet as well.
I did try changing the $B$3:$B$25 type ranges to be B:B, but that doesn't work.

=IF(COUNTIFS($B$3:$B$25,B4,$D$3:$D$25,D4)=COUNTIFS($B$3:$B4,B4,$D$3:$D4,D4), SUMPRODUCT(($B$3:$B$25=$B4)*($D$3:$D$25=$D4)*($R$3:$R$25)),"")

 

[Fluff]

Maybe

=IF(COUNTIFS(B:B,B4,D:D,D4)=COUNTIFS($B$3:$B4,B4,$D$3:$D4,D4), SUMIFS(R:R,B:B,B4,D:D,D4),"")

 

[CaptainGravyBum]

Hi @Fluff
That looks like it's done the trick, thanks for your help .

 

[Fluff]

You're welcome & thanks for the feedback.