Support Board
Date/Time: Thu, 06 Feb 2025 02:35:10 +0000
Post From: Spreadsheet / Series of positive numbers sum
| [2020-04-07 15:37:25] |
| Sawtooth - Posts: 4169 |
|
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 |