Support Board
Date/Time: Thu, 28 Nov 2024 05:47:15 +0000
Sumproduct with Multiple Criteria
View Count: 1064
| [2019-01-05 19:49:48] |
| eaglefutures - Posts: 48 |
|
Hello Support I'm having difficulty in getting this formula to work, could you please assist with the syntax. Have tried multiple options based on what i could dig up on the forum with little success. All the options which I have tried 1) =sumproduct(--(A2:A65)>13,--(A2:A65)<21) 2) =sumproduct((A2:A65)>13*(A2:A65)<21) 3) =sumproduct((A3:A66>13)*(A3:A66<21)) |
| [2019-01-07 17:52:59] |
| John - SC Support - Posts: 36350 |
|
This is definitely not supported by Sierra Chart. You cannot work with ranges in the way that you are. Try to construct a new formula using the available functions: Spreadsheet Functions: Available Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-05-28 00:50:38] |
| user_xyz - Posts: 416 |
|
I am working on a sumproduct solution similar to original post would this work now? 1) =sumproduct(--(A2:A65)>13,--(A2:A65)<21)
Specifically I'm trying to evaluate a number if within range (this works in excel) =IF(SUMPRODUCT(--(AA3:AC3>=E3-4),--(AA3:AC3<=E3+4))>0,1,0) SC mentions in post #2 definitely not supported work with available functions. Sumproduct is listed so unsure if sumproduct was added AFTER 2019 or the formula with the double unary operators will not work. Date Time Of Last Edit: 2023-05-28 01:02:39
|
| [2023-05-30 14:07:25] |
| John - SC Support - Posts: 36350 |
|
The SUMPRODUCT() function in Sierra Chart is fairly straightforward - it just multiplies the values of the various ranges and then adds the products together. There is no support for '--' or '<' operators.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-05-30 14:53:13] |
| user_xyz - Posts: 416 |
|
There is no support for '--' or '<' operators
Thanks ^^^ Therein lie the issue to solutions that I am looking for in this thread. Spreadsheet Count Values Greater Than Zero |
To post a message in this thread, you need to log in with your Sierra Chart account: