Using Text string in Sum formula

[JadeTiger]

Hi,

Could someone help me with this please. I have a need to populate the range
of a Sum formula with a text string that I have dynamically created as the
result of several other variables in my workbook. The text string reads
"SUM(B5:B14)" but every time I try to use it as an argument in a larger
formula in another cell, it doesn't work.

Is there a way to pass text into a formula as an argument?

Thanks

 

[Jacob Skaria]

Have the range as the text string and use INDIRECT()

=SUM(INDIRECT("B5:B14"))

 

[JadeTiger]

Thanks Jacob, it works a treat.

Have the range as the text string and use INDIRECT()

=SUM(INDIRECT("B5:B14"))