Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM and INDIRECT to reference worksheet
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("'"&$A$3&"'!"&CELL("address",B2))). But am having difficulties incorporating SUM where I can sum B:B. Any suggestions would be appreciated. Thanks -- Potatosalad2 ------------------------------------------------------------------------ Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834 View this thread: http://www.excelforum.com/showthread...hreadid=517289 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM and INDIRECT to reference worksheet
If the sheet name is contained in cell A3 then something like =SUM(INDIRECT(A3&"!"&"B:B")) should suffice Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=517289 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM and INDIRECT to reference worksheet
That works great. Thank you very much -- Potatosalad2 ------------------------------------------------------------------------ Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834 View this thread: http://www.excelforum.com/showthread...hreadid=517289 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|