Excel's "INDIRECT" function help

LeVeL

Forum Addict
Joined
Jun 16, 2007
Messages
12,580
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?
 

LeVeL

Forum Addict
Joined
Jun 16, 2007
Messages
12,580
Got it to work using INDEX and MATCH. Tried it with a condition too, using SUMIF - works perfectly. However, now I can't change that into SUMIFS with two conditions. ARGH!

- - - Updated - - -

Never mind, talked myself through it. Please disregard this entire thread :lol:
 
Top