0

My problem is similar to that in this quesion: Row in formula change based on value in another cell, i.e. I want to use the value of a cell as reference to another cell in a formula of yet another cell.

However, I want the value of a cell to only be the part of a cell range. Let me give you an example:

A1 holds worksheet-a

In C1 I'd like to have a forumla that results in =SUM('worksheet-a'!B:B)

Based on the other question, I thought that something like =SUM(INDIRECT(A1)&"!B:B") might do it. Sadly, it does not.

Do you have any ideas?

Thank you!

Community
  • 1
  • 1
msallge
  • 107
  • 1
  • 10

1 Answers1

1

For me it works in this way

=SUM(INDIRECT(CONCATENATE(A1;"!B:B")))

or with ampersand

=SUM(INDIRECT(A1&"!B:B"))
Jirka Š.
  • 3,388
  • 2
  • 15
  • 17
  • 1
    Thank you. Your comment helped me drill down on the issue. Apparently the `-` within the worksheet name caused the problem. I could just avoid worksheet names with a minus. – msallge Jun 27 '13 at 07:12