Dynamic Cell Address Construction

[desktopbbb]

If cell A1="B" and cell A2 = "1", is there a way to construct the
address B1 by combining the contents in A1 and A2 so that address B1
can be used in a formula ? If yes, does it mean that a range address
can be constructed in the same way ?

 

[jaf]

Hi,
Yes, use indirect.
=SUM(INDIRECT(A1&A2):INDIRECT(A3&A4))