Login Page - Create Account

Support Board


Date/Time: Thu, 10 Jul 2025 08:01:11 +0000



Post From: OFFSET Function in Spreadsheet

[2021-12-31 18:22:29]
John - SC Support - Posts: 40812
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