Support Board
Date/Time: Sun, 24 Nov 2024 05:35:41 +0000
Post From: S/Sheet Study - Formula returns #inval! error
| [2013-09-24 22:33:55] |
| |
|
2. As an example, the formula =COUNTIF(AA3:AA12,">50") can be implemented in the non-CLR version as follows: In one of the spreadsheet formula columns enter this formula =IF(AA3>50,1,0). Assuming the prior formula was entered in formula column X, then enter =SUM(X3:X12) in another formula column. The result of this last formula will be the same as =COUNTIF(AA3:AA12,">50").
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2013-09-24 22:34:37
|