SumIf + Vlookup

[Rbveiga]

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

column	L	M
1	23%	1,000.00
2	21%	3,000.00

<tbody>
</tbody>

Sheet3:

A	B
BE	M:M
AT	N:N

<tbody>
</tbody>

 

[Gerald Higgins]

I think you'll need the INDIRECT function to handle the SUM RANGE argument within the SUMIF.

 

[kvsrinivasamurthy]

Change the formula as

=SUMIF(Sheet2!L:L,D1,INDIRECT("Sheet2!"&VLOOKUP(A1,Sheet3!A:B,2,0)))