P
Potatosalad2
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
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