Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing cells containing tab names?
I have cells containing tab names as text, and I want to reference those tab
names in my formulas. In specific, I have the following formula (in various forms and quantities) in about sixty rows and across multiple columns, with each column referring to a different tab for its data: SUMIF(TabName!$A:$A,$B:$B,TabName!$B:$B) I want "TabName" to refer to row 9 of each column, for example, to retrieve the tab name to use. INDIRECT doesn't seem to work; neither does creating a range name for each tab. Many thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |