0:00
hello everyone in this video we'll
0:02
explore how to calculate a cumulative
0:04
sum to effectively track your spending a
0:06
cumulative sum also known as a running
0:08
total continuously adds up values in a
0:10
list giving you a running total at each
0:13
step this allows you to see how your
0:14
data accumulates over time in our
0:17
worksheet column B contains daily
0:18
spending amounts while column C shows
0:21
the cumulative totals allowing us to see
0:23
the running total at a glance to see how
0:25
running total Works let's enter your
0:27
first cumulative sum in celc2 which is
0:29
simply the value from the first day
0:31
spending next in cell C3 add the
0:34
previous cumulative sum calculated in C2
0:37
to the current day spending now apply
0:39
the formula drag it down for the rest of
0:41
your data as you drag the formula down
0:44
Excel will automatically adjust the cell
0:46
references giving you a running total
0:47
for each day this is how the cumulative
0:51
works when you drag the formula down it
0:54
repeats the previous sum in rows where
0:56
the spinning cells are blank to avoid
0:58
this you can use an if function to hide
1:00
the cumulative sum in rows without data
1:02
let's edit the formula in cell C3 and
1:05
copy it down the column with the updated
1:07
formula the sum will only display when
1:09
spending is entered give it a try once
1:12
you enter a spending amount the
1:13
cumulative sum will appear right next to
1:19
it notice that if you miss or delete a
1:22
value in column B say you enter a value
1:24
and B13 leave b14 blank and then enter a
1:28
value and B 15 the cumulative if some
1:30
won't calculate correctly to ensure
1:32
accurate results make sure there are no
1:34
gaps in your list however if you need to
1:36
allow for blank cells you can adjust the
1:38
formula slightly in celc 2 Enter the
1:41
formula as shown on screen this formula
1:44
calculates the cumulative sum even when
1:46
there are gaps in the list the updated
1:48
formula uses a mixed reference where the
1:50
first cell in the range row two remains
1:52
fixed while the second cell adjusts as
1:55
the formula is copied down the column
1:57
this ensures the sum always starts from
1:59
row two and continues to the current row
2:01
so that's how you create a cumulative
2:03
summon Excel I hope you found this video
2:05
helpful if you did don't forget to give
2:08
it a thumbs up and subscribe for more
2:09
Excel tips and tricks thanks for
2:11
watching and see you in the next video