Using Text string in Sum formula
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
|