Substitute for indirect within sumif for dynamic column name

[ajiffity]

Hello, I am trying to find a substitute for a dynamic column name within my sumif formula so I don't use the volatile indirect command. How can I make a reference in a more optimal way so my file isn't so slow due to indirect?

The column name changes from Budget_1, Actual_1, Prior_1 for example and they are all column names in another sheet. I am stuck...thanks in advance


=SUMIFS(INDIRECT($F$9),Main_Co_Dept,CONCATENATE($B14,RIGHT($D$1,4),RIGHT($I$1,4)),EBITDA_Co,CONCATENATE("0000-",RIGHT($D$1,3)))

 

[ajiffity]

In other words what can I switch for the 'indirect($F$9)' part of my sumifs formula

 

[ajiffity]

dont let me down boys - this is the first time ive been stuck in excel

 

[ajiffity]

last reply - maybe I need to add an index match combination within sumifs? or a choose? I can't figure it out, it always throws an error and won't reference the column header