WEBVTT
Kind: captions
Language: en
00:00:00.360 --> 00:00:06.020
In this video, you will calculate the total cost of your monthly expenses using a spreadsheetformula.
00:00:06.260 --> 00:00:10.780
A formula is a mathematical rule that is used
to solve a problem.
00:00:10.780 --> 00:00:13.809
Adding up a long list of numbers takes a long
time.
00:00:13.809 --> 00:00:17.540
A formula does that work for you and helps
you avoid errors.
00:00:17.540 --> 00:00:20.820
Formulas also update automatically when you
enter new data.
00:00:20.820 --> 00:00:25.120
This can be helpful when you are considering
different options for reducing your expenses.
00:00:25.360 --> 00:00:29.060
For example, what happens when you cut down
on your entertainment expenses,
00:00:29.060 --> 00:00:31.040
but your car payment goes up?
00:00:31.640 --> 00:00:33.630
Will the total cost balance out?
00:00:33.630 --> 00:00:35.480
A formula will let you know.
00:00:35.480 --> 00:00:39.430
A SUM function is a formula that adds up the
values in cells.
00:00:39.430 --> 00:00:44.000
To begin, select the cell two rows beneath
the final entry in your cost column.
00:00:44.000 --> 00:00:48.160
Enter the formula in this cell, so the total
cost appears here.
00:00:48.160 --> 00:00:51.360
Formulas in Google Sheets always begin with
an equals sign.
00:00:51.760 --> 00:00:52.920
Type the word sum.
00:00:55.300 --> 00:00:58.420
As you type, a dropdown menu suggests different
options.
00:00:58.420 --> 00:00:59.560
Select SUM.
00:01:04.200 --> 00:01:07.120
Next, select the cells you’d like to add up.
00:01:07.120 --> 00:01:12.740
In this case, you’re adding the item costs
in the range of cells from B2 to B18.
00:01:13.580 --> 00:01:16.860
Close the parentheses to complete your formula,
and press enter.
00:01:17.840 --> 00:01:20.500
This is the total cost of your monthly expenses.
00:01:21.500 --> 00:01:22.220
Nice job!
00:01:22.810 --> 00:01:25.980
Now that you’ve calculated the total cost
of your monthly expenses,
00:01:25.980 --> 00:01:28.780
move on to the next video to wrap up the lesson.
00:01:29.300 --> 00:01:30.520
Now, it’s your turn.
00:01:30.520 --> 00:01:34.400
Use the SUM function
to calculate the total cost of your expenses.