Support Board
Date/Time: Tue, 04 Mar 2025 11:30:35 +0000
Spreadsheet study. Sum of values with irregular row intervals.
View Count: 705
| [2021-11-30 22:10:59] |
| Mario Escalante - Posts: 21 |
|
Hello for a detailed explanation of the problem please go to: https://www.mrexcel.com/board/threads/sum-of-values-with-irregular-row-intervals.1188950/ I'm trying to use the following formula to sum values from different columns that are also at different row intervals. =IF(B1=0,0,B1+INDEX(A:A,MIN(IF(A1:A10,ROW(A1:A10))))) the formula works just fine on excel and I don't see why it wouldn't work on SC since all those functions are supported by SC. Any comments about this behavior or even a different approach for resolving my problem is well received. Thank you for the help. |
| [2021-11-30 23:07:30] |
| John - SC Support - Posts: 38341 |
|
There are a few things in there that will not work in Sierra Chart. To begin with, the IF statement farthest to the right does not have a "Value if False" entry. It should look like IF(A1:A10,ROW(A1:A10),0). Also, within that IF statement, Sierra Chart does not evaluate A1:A10 as an equation to return a True/False value (in fact, I have no idea myself what exactly that does within an IF statement within Excel). Therefore, you would need to change that to whatever it is checking for. For the most reliable, advanced, and zero cost futures order routing, use 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: