• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Help!

kris9172

New Member
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!
 
May……..

=IFERROR(1/(1/SUMIFS(INDIRECT("'"&E$20&"'!H:H"),INDIRECT("'"&E$20&"'!C:C"),$B22,INDIRECT("'"&E$20&"'!D:D"),$C22)),IFERROR(1/(1/SUMIFS(INDIRECT("'"&E$20&"'!I:I"),INDIRECT("'"&E$20&"'!C:C"),$B22,INDIRECT("'"&E$20&"'!D:D"),$C22)),""))

Regards
 
Back
Top