Support Board
Date/Time: Fri, 09 May 2025 23:51:16 +0000
Spreadsheet functions INDIRECT & CONCATENATE examples
View Count: 1342
| [2016-03-25 03:38:39] |
| User553714 - Posts: 184 |
|
Hi, I am trying to use a combination of concantenate to form a reference to a cell range from text i.e =CONCATENATE("BC3:", "BC", TEXT(H54)) which returns BC3:BC7 I am then trying to use INDIRECT to use that text formed cell reference to return for example the sum of that range =SUM(INDIRECT(CONCATENATE("BC3:", "BC", TEXT(H54)) )) but I keep on getting #REF! or #SYNTAX! Is it possible to use text ranges with SC spreadsheet function INDIRECT and can you please provide an example of how I can do this? Regards |
| [2016-03-25 03:40:45] |
| |
|
We have to check but we do not think this is supported. The errors you are getting confirm this. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-03-25 09:11:20] |
| User553714 - Posts: 184 |
|
It would be great if you can add this functionality to allow INDIRECT to accept text cell range references? This is not urgent as I only had them in mind for a specific task and there are other work arounds. It would also be great if the change is logged in the SC version change-log which I regularly check to see if there is anything specific worth upgrading for. REgards |
| [2016-06-27 16:57:36] |
| User316362 - Posts: 211 |
|
I agree. This would be nice to have. I can create a dynamic range and convert it to text but cannot find a way to work around the INDIRECT limitation of using just a cell reference. Any alternative ways to handle this? for instance MAX(INDIRECT("AK1:AK10")) will not work. I did find a workaround. So nevermind Date Time Of Last Edit: 2016-06-27 17:07:27
|
| [2016-06-27 19:20:38] |
| |
|
We will see if this is not difficult to add.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: