Referencing cells containing tab names?

N

nate_a

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.
 
B

Bob Phillips

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

should work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Copy addition formula of non-consecutive horizontal cells 2
Cells not updated automatically 3
Using tab names in formulae 0
Referencing an External Cell 1
How to get range names to Apply across multiple tabs 1
Search tab using indirect for number of times in a range 3
Drop down list control value in vba 2

Top