Support Board
Date/Time: Sat, 21 Dec 2024 13:13:24 +0000
New spreadsheet syntax
View Count: 1057
| [2014-12-07 06:52:23] |
| enemyspy - Posts: 306 |
|
Hi, I am looking for an alternative way to accomplish the following excel syntax formula within the syntax of the new sierra spreadsheets: =SUM(INDIRECT(ADDRESS(MATCH(1.001,SHEET1!$BO$1:BO20000,0),310,4,TRUE,"SHEET2")):INDIRECT(ADDRESS(MATCH(2,SHEET1!BO1:BO20000,1),310,4,TRUE))) or more simply sum( address("defines first half of range on other sheet) : address("defines second half of range on other sheet) Currently unable to define a range using address function. Is there another way to do this? |
| [2014-12-07 22:28:15] |
| |
|
We will work on adding a two-part ADDRESS function which will return a range reference.
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: