Support Board
Date/Time: Sun, 05 Apr 2026 09:43:56 +0000
Post From: Spreadsheet / Series of positive numbers sum
| [2020-04-07 15:37:25] |
| Sawtooth - Posts: 4322 |
|
Try this in P3: =IF(AND(O4=0,O3>0),O3,IF(AND(O4>0,O3>0),O3+P4,P4)) This will increment the sum in a series, then be persistent until the next series. Here are more examples of persistent and incrementing variables: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables |