software

I have 9 reference worksheets each titled by number and one summary
worksheet with all nine numbers in column A. I would like to write a
formula that references the number in column A, looks up the tab, and
sums a column in that tab, say column B. I can get INDIRECT to work
looking up an address ie:
=(INDIRECT(quot;'quot;amp;$A$3amp;quot;'!quot;amp;CELL(quot;addressquot;,B2))).
But am having difficulties incorporating SUM where I can sum B:B.
Any suggestions would be appreciated.

Thanks--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: www.excelforum.com/member.php...oamp;userid=20834
View this thread: www.excelforum.com/showthread...hreadid=517289
If the sheet name is contained in cell A3 then something like

=SUM(INDIRECT(A3amp;quot;!quot;amp;quot;B:Bquot;))

should suffice

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=517289
That works great. Thank you very much--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: www.excelforum.com/member.php...oamp;userid=20834
View this thread: www.excelforum.com/showthread...hreadid=517289