LeVeL
Forum Addict
- Joined
- Jun 16, 2007
- Messages
- 13,246
Here's the setup:
In Sheet1 I have a cell, Z2, where I typed "Sheet2".
In Sheet2 I have column AB, which is called "Funds".
I want a formula in Sheet1 to sum up all the values in the column "Funds" (which is in Sheet2). By using INDIRECT(Z2&"AB5:AB200") I am able to accomplish this but the next step is to have the formula reference the column [Funds], rather than me manually telling it that Funds is specifically column AB.
I tried INDIRECT(Z2&"[Funds]") as well as INDIRECT(Z2&[Funds]) and those don't work so what am I missing here?
In Sheet1 I have a cell, Z2, where I typed "Sheet2".
In Sheet2 I have column AB, which is called "Funds".
I want a formula in Sheet1 to sum up all the values in the column "Funds" (which is in Sheet2). By using INDIRECT(Z2&"AB5:AB200") I am able to accomplish this but the next step is to have the formula reference the column [Funds], rather than me manually telling it that Funds is specifically column AB.
I tried INDIRECT(Z2&"[Funds]") as well as INDIRECT(Z2&[Funds]) and those don't work so what am I missing here?