Embed Index Match into Sumif

[lipper79]

Hello,

I have tried searching the board, but have been unable to find an exact match to my question. I am trying to create a sumif formula based on an index match. In the attached file, I need to sum all of the values in "4Q16 Curr P18-49 Imp" (column U) if the Plan Status (column B) is "H". I want to use an index match, because the "4Q16 Curr P18-49 Imp" heading will change based on the filter criteria I am using to generate my reports (eg. next time it might be 3Q16). The answer should be 12,952.

Thank you in advance for your assistance.

[alansidman]

Try this. Put the Column Letter in A1

=SUMIF($B$4:$B$12,"H",INDIRECT(A1 & 4))

[Tony Valko]

Try this...

T14 = 4Q16 Curr P18-49 Imp

=SUMIF(B5:B12,"H",INDEX(C5:V12,0,MATCH(T14,C4:V4,0)))

[lipper79]

Thank you Tony. This worked. Much appreciated!!!

[Tony Valko]

You're welcome. Thanks for the feedback!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.