Sum with a text value from other cell

[alcalina]

Hello,

I have a simple formula, and this is

Please Login or Register  to view this content.

6m is my sheet. But I want to change with a value from other cell.

Something like this

Please Login or Register  to view this content.

Inside A1 cell has 6m ( the name of the sheet)
I want to text inside A1 be evaluate and put as part of the formula code.


I think it is simple, but I am having trouble to search.
I tried text inside formula excel. But I am not getting anywhere near. So I decide to ask for help.

Thanks

[Richard Buttrey]

Hi, and welcome to the forum.

Please Login or Register  to view this content.

[alcalina]

Tks very much. It worked like a charm.
I realize since we are using text in the formula, when I drag the formula A1 will change. But B2:B85 is not change since is a text. It is usefull if you do not want to change formula.

Please Login or Register  to view this content.