One way:
B1: =SUM(INDIRECT("'" & A1 & "'!B4:B10"))
In article ,
"Łukasz Czech" wrote:
Hello,
I would like to make link to different worksheet with name specified in
different column
eg.
A B
1 Sheet1 =SUM(A1!B4:B10)
2 Sheet2 =SUM(A2!B4:B10)
where column A stores names of worksheets and B sums cells from worksheets
from A column.
Thanks for solutions.
Lukasz
|