Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
Use INDIRECT to build the variable range reference: =Sum(INDIRECT("Variable"&Q1&Q2,TRUE)) HTH Cordially Pascal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shortcut for referring to tab names in formulas | Excel Worksheet Functions | |||
Replace variable row number in formulas | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Locking Sheet names in formulas | Excel Worksheet Functions | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |