WEBVTT

0
00:04.850 --> 00:06.360
Okay guys let's have a look at how

1
00:06.440 --> 00:13.250
we adapt the autosum function that we've already used, to work out the sum of a row of data.

2
00:13.250 --> 00:18.890
Now, at the moment, in these cells we still have the old fashioned formula of this cell plus that cell

3
00:18.890 --> 00:24.910
plus that cell plus that cell.
So what I'm going to do is I'm just going to delete that so we can start afresh.

4
00:25.310 --> 00:31.400
Now if we take a quick look at the autosum function, the formula that was written for us automatically

5
00:31.400 --> 00:37.670
when we used autosum, we can see that the structure of the formula is the equal sign, which means it's

6
00:37.670 --> 00:38.580
a formula,

7
00:38.590 --> 00:45.800
the function name, which is SUM, brackets that open, the range that we want to sum, and the brackets to

8
00:45.800 --> 00:47.330
close off the arguments.

9
00:47.390 --> 00:47.740
Okay.

10
00:47.740 --> 00:52.860
And what we're going to do is we're going to copy that and we're going to use it over the side here.

11
00:52.970 --> 01:00.860
One quick way of doing this, is if you come up to the formula bar and delete the equal sign, hit enter,

12
01:01.160 --> 01:07.940
you can see that now Excel has treated this, not as a formula, but as a string...that is, it's just letters

13
01:07.940 --> 01:08.860
and numbers.

14
01:09.090 --> 01:13.380
Okay, so now we've done tha,t we can easily refer back to it so we can copy it.

15
01:13.600 --> 01:13.850
OK.

16
01:13.880 --> 01:19.460
So, we're going to come up here, and we're going to type "=", because it's a formula that when entering...

17
01:19.460 --> 01:26.090
...we're going to type SUM, because we can see here that the function is SUM, we're going to copy that

18
01:26.090 --> 01:33.140
again by entering a bracket, and then we can see that we have an Excel tooltip that tells us what we need

19
01:33.140 --> 01:33.920
to enter next.

20
01:33.970 --> 01:36.170
It is a number then a comma...

21
01:36.200 --> 01:37.480
Then the number then a comma.

22
01:37.640 --> 01:43.460
So we could do it that way...let's just do it that way for a second...so if we hit that, and hit comma, you

23
01:43.460 --> 01:46.180
can see that "number 1" has been highlighted in the tooltip.

24
01:46.190 --> 01:51.570
When I hit comma, the tooltip will expand, and say now you need to enter number two.

25
01:51.590 --> 01:57.580
So if I left click the second cell, hit comma, it will then say number 3, and on and on and on.

26
01:57.980 --> 02:02.060
We're not going to do that because that's almost the same as the long way of doing it.

27
02:02.060 --> 02:05.810
So what we're going to do is, we're going to highlight the range that we want to add up.

28
02:05.860 --> 02:13.140
So I'm going to left click cell B5, keep my mouse button pressed, and drag over to Friday.

29
02:13.160 --> 02:19.250
So now we can see that the format of the formula has been copied, so we can see down the bottom that

30
02:19.250 --> 02:23.510
we have some open brackets, a range, and close brackets.

31
02:23.660 --> 02:30.830
So all we need to do now is let go of the left mouse button, hit, "Shift", close brackets, hit "Enter" and there

32
02:30.830 --> 02:31.520
you go.

33
02:31.520 --> 02:34.120
We now have our sum of 40.

34
02:34.140 --> 02:39.380
Now let me just come back down here and reinsert our equals sign, there you go...

35
02:39.380 --> 02:41.540
So now we have a formula down the bottom.

36
02:41.750 --> 02:47.330
And as we learned in the last lecture, just to quickly copy that down, hover over the corner to the drag

37
02:47.330 --> 02:52.500
handle until cursor changes to the black cross, double click and there you go.

38
02:52.520 --> 02:56.450
We now know our total sales for each of our fruits and veggies.

39
02:56.630 --> 03:01.860
And we also know, actually I'd better put total in the bottom so we know what it is...

40
03:02.150 --> 03:06.440
And we also know the total of our sales for the day by items.

41
03:06.650 --> 03:07.340
So there you go.

42
03:07.340 --> 03:12.690
That's how you adapt and autosum from a column and use it in a row.

43
03:12.770 --> 03:14.130
So you in the next lecture.