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

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

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

--
If this post helps click Yes
---------------
Jacob Skaria


"JadeTiger" wrote:

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

Thanks Jacob, it works a treat.

"Jacob Skaria" wrote:

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

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

--
If this post helps click Yes
---------------
Jacob Skaria


"JadeTiger" wrote:

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