Support Board
Date/Time: Wed, 05 Mar 2025 01:13:19 +0000
Post From: OFFSET Function in Spreadsheet
| [2021-12-31 18:22:29] |
| John - SC Support - Posts: 38380 |
|
The Width and Length values have to be non-zero (same as Excel). So if you wanted to sum the value in cell BC3, you would enter =SUM(OFFSET(BC3, 0, 0, 1, 1)) Therefore, it looks like you would just need to change your formula to the following (assuming that a value of 1 in Z3 really means a total of 2 columns): =SUM(OFFSET(BC3, 0, 0, 1, Z3 + 1)) This will also eliminate the issue with Z3 being 0, since it adds 1 to the value. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |