Support Board
Date/Time: Mon, 25 Nov 2024 09:32:29 +0000
Post From: Spread Sheet formulas
| [2024-03-14 16:25:01] |
| John - SC Support - Posts: 36238 |
|
To use a cell as the reference value, you need to use a combination of CELL, CONCATENATE, and INDIRECT functions. For example the following: =SUM(K3:INDIRECT(CONCATENATE("K", CELL("contents", $S$3)))) This gives the sum of values in the K column from row 3 to the row defined in cell S3. Note that the word "contents" needs to entered in lowercase. The definitions of these functions is at the following link: Spreadsheet Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |