Support Board
Date/Time: Thu, 13 Feb 2025 13:47:09 +0000
Post From: Help with a Spreadsheet Sum column upon a condition then start from 0
| [2020-12-05 23:19:37] |
| User215984 - Posts: 24 |
|
tomgilb, Thanks for your time!!!! I guess this is like a zig-zag volume type of calculation restarts to sum when a change in trend. I'm using col W as a boolean for the (close <= close[-1]) test. Col Z sums everything for col X, until col W changes state and then starts re-sum from the current row until another col W change state Date Time Of Last Edit: 2020-12-05 23:27:58
|
S-2.JPG