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.
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.