Hello ,
Could you please help me with one excel formula?
I am trying to have dynamic sum range, where the sum range column changed based on cell value
Below you can find the formula which I am trying to build:
Sheet1 :
D1="23%"
A1="BE"
SUMIF(Sheet2!L:L,D1,"Sheet2!"&VLOOKUP(A1,'sheet3'!A:B,2,0))
Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD]column[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]23%[/TD]
[TD]1,000.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]21%[/TD]
[TD]3,000.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet3:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]BE[/TD]
[TD]M:M[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]N:N[/TD]
[/TR]
</tbody>[/TABLE]
Could you please help me with one excel formula?
I am trying to have dynamic sum range, where the sum range column changed based on cell value
Below you can find the formula which I am trying to build:
Sheet1 :
D1="23%"
A1="BE"
SUMIF(Sheet2!L:L,D1,"Sheet2!"&VLOOKUP(A1,'sheet3'!A:B,2,0))
Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD]column[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]23%[/TD]
[TD]1,000.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]21%[/TD]
[TD]3,000.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet3:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]BE[/TD]
[TD]M:M[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]N:N[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: