Support Board

Date/Time: Fri, 24 Jan 2025 03:47:45 +0000

Post From: Default Spreadsheet Study - Issues referencing past values

[2018-12-19 09:25:38] Link To Thread - Link To Post [Go To First Post]
User833285 - Posts: 4
Dear Sierra Chart Team, I am trying to add together certain values based on a dynamically calcualeted range length in my spreadsheet study. While formula (1): =SUM(BC3:INDIRECT(R3)) with R3 being =ADDRESS(3,COLUMN(BC3)+M3,4) works just fine in the row that is the most recent, copying down the formula (applying it to past values) does not yield the same result. For example referencing the previous row: =SUM(BC4:INDIRECT(R4)) returns a #REF! error. I was looking up the documentation about the INDIRECT(...) Formula wich outlines certain limitations. Is the issue I am experiencing related to this or is there a diffrent mistake? Would be very grateful for your support, thank you for this great programm. Best Grinsend Date Time Of Last Edit: 2018-12-19 19:46:23


Spreadshet_Indirect_REF.PNG / V - Attached On 2018-12-19 09:25:01 UTC - Size: 34.78 KB - 277 views Attachment Deleted.