I'm working with the following formula and hoping someone can give me some insight on how to tweak it....
=IFERROR(SUMIFS(INDIRECT("'"&E$20&"'!"&"H:H"),INDIRECT("'"&E$20&"'!"&"C:C"),$B22,INDIRECT("'"&E$20&"'!"&"D:D"),$C22),0)
Currently, the heading for column H is "Amount" on all of the subsequent tabs with data. But if I add a column into one of the tabs that moves the "Amount" column into column I, then the formula no longer works. Is there any way to utilize the Match function (or something else) so that it always pulls the information in the "Amount" column?
For reference - the header for column C is "Obj Acct" and D is "Sub Acct".
Thanks in advance for any help/suggestions!
=IFERROR(SUMIFS(INDIRECT("'"&E$20&"'!"&"H:H"),INDIRECT("'"&E$20&"'!"&"C:C"),$B22,INDIRECT("'"&E$20&"'!"&"D:D"),$C22),0)
Currently, the heading for column H is "Amount" on all of the subsequent tabs with data. But if I add a column into one of the tabs that moves the "Amount" column into column I, then the formula no longer works. Is there any way to utilize the Match function (or something else) so that it always pulls the information in the "Amount" column?
For reference - the header for column C is "Obj Acct" and D is "Sub Acct".
Thanks in advance for any help/suggestions!