Support Board
Date/Time: Fri, 24 Jan 2025 03:32:22 +0000
Post From: Default Spreadsheet Study - Issues referencing past values
| [2018-12-19 19:27:30] |
| |
|
The problem is that after the first row, the results are trying to sum backwards, which is not allowed. For example, in Row 4 the result of the INDIRECT would give: SUM(BC4:BE3). Since row 4 is greater than row 3, it does not know what data you want to sum. Also, keep in mind that when summing across columns it only uses the square of data that is between the upper left hand corner defined by the first parameter and the bottom left hand corner defined by the second parameter. And the upper left hand corner must be a lower row number than the lower right hand corner. 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 |