Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 15:14:31 +0000
Post From: How to SUM spreadsheet column consisting of +Num's,-Num's, and 0's while...
| [2018-09-13 21:45:22] |
| Sawtooth - Posts: 3993 |
|
Yes, the ZZ Line Length is in points. Same formulas, using a specific ID# and SG#: Q3: =IF(ID2.SG4@3>0,ID2.SG4@3,0) this returns only the positive Line Lengths. R3: =SUM(Q3:Q1002)/$J$21 this will sum positive Line Lengths and convert to ticks. S3: =IF(ID2.SG4@3<0,ID2.SG4@3,0) this returns only the negative Line Lengths. T3: =SUM(S3:S1002)/$J$21 this will sum negative Line Lengths and convert to ticks. Date Time Of Last Edit: 2018-09-15 00:27:40
|