Support Board
Date/Time: Thu, 22 Jan 2026 23:38:19 +0000
SUMPRODUCT
View Count: 15
| [2026-01-22 19:35:49] |
| User411320 - Posts: 368 |
|
Hello, i'm trying to use to 2 formulas using the SUMPRODUCT function and I'm getting #VALUE!. The formulas are as follows =SUMPRODUCT(100*(E3:E12-B3:B12)/B2:B12) =SUMPRODUCT(SIGN(E3:E5-B3:B5)) what am I doing wrong |
| [2026-01-22 19:48:51] |
| John - SC Support - Posts: 44164 |
|
You are trying to perform an action within the SUMPRODUCT function, which you can not do. The SUMPRODUCT needs to have the range of values and only the range of values. For instance, to multiply each row of B and E columns and then sum each row, you would enter the following: =SUMPRODUCT(E3:E12, B3:B12) Anything you want to do apart from that SUMPRODUCT has to be done outside of the function, such as: =100*SUMPRODUCT(E3:E12, B3:B12) Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#SUMPRODUCT_Function 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: