Cumulative sum of value with arrayformula and reset if =>20 - Google sheets

Asked Sep 07 '22 at 12:15

Active Sep 07 '22 at 12:41

Viewed 59 times

I have values in A column to be cumulatively summed and reset the sum if => 20
20 can be any number later on.
See this similar Question It might help.

Make a copy of the example sheet.

Value	Desired
13	13
7	20
5	5
6	11
8	19
8	27
21	21
6	6
15	21
12	12
13	25
3	3
2	5
12	17
6	23
6	6
3	9
8	17
14	31
5	5
18	23
3	26

edited Sep 07 '22 at 12:41

asked Sep 07 '22 at 12:15

Osm

2,699
2
4
26

Whomever gives a vote down, please comment your remark, thanks. – Osm Sep 07 '22 at 14:36

Value	Desired
13	13
7	20
5	5
6	11
8	19
8	27
21	21
6	6
15	21
12	12
13	25
3	3
2	5
12	17
6	23
6	6
3	9
8	17
14	31
5	5
18	23
3	26

Value	Desired
13	13
7	20
5	5
6	11
8	19
8	27
21	21
6	6
15	21
12	12
13	25
3	3
2	5
12	17
6	23
6	6
3	9
8	17
14	31
5	5
18	23
3	26

Cumulative sum of value with arrayformula and reset if =>20 - Google sheets

0 Answers0

Value	Desired
13	13
7	20
5	5
6	11
8	19
8	27
21	21
6	6
15	21
12	12
13	25
3	3
2	5
12	17
6	23
6	6
3	9
8	17
14	31
5	5
18	23
3	26