Support Board
Date/Time: Thu, 22 Jan 2026 23:35:00 +0000
Post From: SUMPRODUCT
| [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 |