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 !!
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 !!