Placing INDIRECT in a SUMIFS formula

[Duck13]

Hey

I'm trying to place a indirect formula, in a SUMIFIS formula. The SUMIFIS formula (SUM.HVISER), is currently drawing data from a sheet named T2_2021. I want it to draw the name from B3 instead (Which is currently named T2_2021). So in the future i can change B3 to for example T1_2022, and it will draw data from a worksheet named T1_2022.

The formula is currently as follows

=SUM.HVISER(T2_2021!$M:$M;T2_2021!$N:$N;FREMSKRIVNING!$B$7;T2_2021!$K:$K;FREMSKRIVNING!B23;T2_2021!$F:$F;FREMSKRIVNING!$A$13)

FREMSKRIVNING is simply a external worksheet, which should stay. The problem is changing T2_2021 to INDIRECT B3.

 

[jasonb75]

Replace T2_2021!$M:$M with INDIRECT("'"&$B$3&"'!$M:$M") then do the same for the other similar ranges, changing the column reference as necessary.

 

[Duck13]

It worked like a charm. If you have the time, could you explain or link to some information, regarding the logic behind?