Absolute cell changes when I insert a row

[MonBarks]

Hello Gurus,
I'm using this formula =SUMIFS('Weekly Invoices Record'!J5:J2045,'Weekly Invoices Record'!A5:A2045,'Create New Weekly Invoice '!$J$5:$J$5) which works fine until I insert a row in the Weekly Invoices Record sheet, then it starts looking on row 6, instead of 5, even though it was an absolute reference. I think I might need to use INDIRECT within my SUMIFS formula, but I just can't get my head around the syntax. Please help !!

 

[mrshl9898]

=SUMIFS( 'Weekly Invoices Record'!J5:J2045,'Weekly Invoices Record'!A5:A2045,INDIRECT("'Create New Weekly Invoice '!J"&ROW(A5)))

 

[MonBarks]

=SUMIFS( 'Weekly Invoices Record'!J5:J2045,'Weekly Invoices Record'!A5:A2045,INDIRECT("'Create New Weekly Invoice '!J"&ROW(A5)))

Thank you so much, it works perfectly. I was getting in such a pickle with "Indirect" all over the place )