1
00:00:00,080 --> 00:00:03,761
A running total works for three rows, then the next entry

2
00:00:03,761 --> 00:00:06,773
appears without a total because no formula was copied.

3
00:00:06,773 --> 00:00:10,455
In this fictional Google Sheet, five, negative two, and seven should

4
00:00:10,455 --> 00:00:12,463
accumulate to five, three, and ten.

5
00:00:12,463 --> 00:00:16,144
We will use one SCAN formula with a bounded future range,

6
00:00:16,144 --> 00:00:19,825
add a fourth amount of four, and verify that the fourth

7
00:00:19,825 --> 00:00:22,168
running total becomes fourteen without filling down.

8
00:00:22,168 --> 00:00:25,849
This pattern assumes a contiguous amount list within the chosen range.

9
00:00:26,449 --> 00:00:31,050
Load the fictional CSV into a disposable Google Sheet and keep

10
00:00:31,050 --> 00:00:35,232
amounts in B2 through B4: five, negative two, and seven.

11
00:00:35,232 --> 00:00:40,669
Before entering a formula, add them on paper: five, then three, then ten.

12
00:00:40,669 --> 00:00:44,851
This independent check catches an incorrect cumulative formula even if

13
00:00:44,851 --> 00:00:46,524
its output looks plausible.

14
00:00:47,124 --> 00:00:52,061
Leave C2 and the cells below it empty. In C2 enter

15
00:00:52,061 --> 00:00:57,447
=SCAN(0,FILTER(B2:B1000,B2:B1000<>""),LAMBDA(total,amount,total+amount)).

16
00:00:57,447 --> 00:01:02,385
SCAN returns every intermediate sum, while FILTER sends it only nonblank

17
00:01:02,385 --> 00:01:05,526
amounts from the bounded B2:B1000 range.

18
00:01:05,526 --> 00:01:11,361
The two Lambda names are placeholders for the carried total and current amount.

19
00:01:11,961 --> 00:01:15,555
Read C2, C3, and C4: five, three, and ten.

20
00:01:15,555 --> 00:01:19,948
A common error is using a plain SUM over the entire

21
00:01:19,948 --> 00:01:24,341
column in every row, which repeats the final total rather than

22
00:01:24,341 --> 00:01:25,938
displaying each intermediate balance.

23
00:01:25,938 --> 00:01:30,731
Another is typing into the spill range, which blocks the array result.

24
00:01:31,331 --> 00:01:35,416
Add Adjustment with amount four in the next contiguous row, B5,

25
00:01:35,416 --> 00:01:38,387
which is inside the B2:B1000 source range.

26
00:01:38,387 --> 00:01:40,616
Do not copy the C2 formula.

27
00:01:40,616 --> 00:01:44,701
The existing SCAN result should grow into C5 and display fourteen.

28
00:01:44,701 --> 00:01:48,787
If it does not, check that the B5 amount is a

29
00:01:48,787 --> 00:01:52,872
number rather than text, and that C5 has no blocking value.

30
00:01:53,472 --> 00:01:55,892
The source range ends at B1000.

31
00:01:55,892 --> 00:02:01,943
If your data grows beyond that row, expand both B2:B1000 references in the formula.

32
00:02:01,943 --> 00:02:06,381
If your data includes blank separator rows, FILTER compresses them and

33
00:02:06,381 --> 00:02:10,818
the running results no longer align with the original row labels.

34
00:02:10,818 --> 00:02:16,869
For that layout, choose a row-aware formula or a conventional fill-down method instead.

35
00:02:17,469 --> 00:02:20,688
The original running totals are five, three, and ten.

36
00:02:20,688 --> 00:02:24,621
After adding a contiguous fourth row with amount four inside the

37
00:02:24,621 --> 00:02:28,912
covered range, the same formula spills fourteen into the next total cell.

38
00:02:28,912 --> 00:02:32,488
No source amount changed and no extra formula was copied.

39
00:02:32,488 --> 00:02:37,136
If your list grows past row one thousand, expand the formula's range.

40
00:02:37,136 --> 00:02:41,069
If your sheet has blank separator rows, use a different pattern.

41
00:02:41,069 --> 00:02:43,930
The guide includes the exact exercise and caveat.