good morning everyone
I want to say thanks in advance; My query consists of whether a formula or procedure can be made in the appsheet that allows me a cumulative sum in the same cell:
For example, values are entered in cell A1 and the sum is accumulated in cell B2.
regards
You can certainly do that using Spreadsheet formulas - AppSheet Help. It’s also possible using an App formula along the lines of one of the following. Depending on your data volume and app design, neither technique may be sufficiently performant.
[SUM](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=sum)([SELECT](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=select()(Table[A], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))
SUM([LIST](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=list()([A], [LOOKUP](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=lookup)([_THISROW].[_ROWNUMBER] - 1, "Table", "_ROWNUMBER", "B")))
3 Likes