INDIRECT function doesn't work with range reference
INDIRECT function doesn't work with range reference
This formula returns correct results:
=DSUM(Bank.A4:H249;"amt";$K$6:$L$7)
This formula
=DSUM(INDIRECT(L1);"amt";$K$6:$L$7)
with Bank.A4:H249 in Cell L1 returns #VALUE!