How to use sumifs with a data range for dynamic updating

[Sol81]

Hi,

I'm a beginner-medium excel user and trying to set up my spread sheet that sumifs certain transaction codes in between certain date ranges as I have sevral contribution types, but I want them summed under one simple contribution heading on the main sheet.

Currently I'm adding additional sumifs together for each new transaction code, as shown below:

=SUMIFS(Transactions!$G:$G,Transactions!$B:$B,">="&$AA3,Transactions!$B:$B,"<="&$AB3,Transactions!$F:$F,Codes!$F$19)+SUMIFS(Transactions!$G:$G,Transactions!$B:$B,">="&$AA3,Transactions!$B:$B,"<="&$AB3,Transactions!$F:$F,Codes!$F$20)

I found a sumproduct that worked however it really slows down my spreadsheet and won't be viable to use:

=(SUMPRODUCT(--(ISNUMBER(MATCH(Transactions!$F:$F,INDIRECT(Codes!$F$18),0)))*(Transactions!$B:$B>=Data!$AA2)*(Transactions!$B:$B<=Data!$AB2),Transactions!$G:$G))*-1

I don't actually know how the sumproduct formula works, only that the indirect function allows me to reference the cell range, and so long as the transaction code is in the correct range, it will automatically be summed with the other transaction codes in the same data range and also wihtin the specified dates.

I was thinking that something like this would work, where Codes!$F$18 is the reference cell containing the data range name:

=SUMIFS(Transactions!$G:$G,Transactions!$B:$B,">="&$AA2,Transactions!$B:$B,"<="&$AB2,Transactions!$F:$F,INDIRECT(Codes!$F$18))

however I always get a 0.

Is there a way to easily reference an entire data range within a sumifs formula as well as a date range or do I need something more powerful?

Thanks in advance.