Using Text string in Sum formula
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 |
Using Text string in Sum formula
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 |
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 |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com