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.

=SUMIF(INDIRECT("'"&A9&"'!$A:$A"),$B:$B,INDIRECT(" '"&A9&"'!$B:$B"))

should work

--
HTH

Bob Phillips

"nate_a" wrote in message
...
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.

That worked great. Thank you!

Nate A.

"Bob Phillips" wrote:

=SUMIF(INDIRECT("'"&A9&"'!$A:$A"),$B:$B,INDIRECT(" '"&A9&"'!$B:$B"))

should work

--
HTH

Bob Phillips

"nate_a" wrote in message
...
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.