Support Board
Date/Time: Thu, 06 Feb 2025 03:10:35 +0000
Post From: Spreadsheet / Series of positive numbers sum
| [2020-04-08 12:31:36] |
| Sawtooth - Posts: 4169 |
|
Try this in P3: =IF(O3=0,0,IF(O3>0,O3+P4,P4)) This will increment the sum in a series, then return 0 when the series ends. If you only want the final sum, and not the intermediate ones, you'll need to use another separate Formula Column, e.g. R3: =IF(AND(P3>0,P2=0),P3,0) Note that the final sum can't be known until P3 is zero. |