Support Board
Date/Time: Fri, 22 Nov 2024 23:12:53 +0000
Post From: spreadsheet COUNTIF() across columns
| [2024-09-27 13:45:50] |
| John - SC Support - Posts: 36238 |
|
In order to do the equivalent of COUNTIF() you need to use multiple columns and use and IF() function with a SUM() function. For what you want, you would need to start with multiple columns to first test if the items in CT3 to DX3 are greater than 0. So you would start with the following in a cell somewhere: =IF(CT3 > 0, 1, 0) You would need to do this for each column, so you would need another formula that is the following: =IF(CU3 > 0, 1, 0) and so on. Then you can sum the 1's by using the formula: =SUM(MT3:NX3) Where MT is the first column you entered the IF() statement in. You could also do this vertically by writing each formula if a different cell going down. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |