1
00:00:01,170 --> 00:00:07,370
Now let's take a look at two very easy to use functions, the "sum" and the "average" functions.

2
00:00:07,530 --> 00:00:14,220
What we want to do here is get the total for yearly salary and previous year's salary and down here

3
00:00:14,300 --> 00:00:17,080
we want to get the average for each of these.

4
00:00:17,100 --> 00:00:23,940
Now for the total, we can type in these "sum" function from scratch. Open the bracket, we need to give it

5
00:00:23,940 --> 00:00:27,850
the range of cells that we want to sum, C5 to C12.

6
00:00:27,870 --> 00:00:34,140
Close the bracket, Press enter or control+enter if you want to stay in the same cell.

7
00:00:34,140 --> 00:00:35,040
In a previous lecture

8
00:00:35,040 --> 00:00:40,220
we saw an alternate way of doing this and that was to use auto sum.

9
00:00:40,260 --> 00:00:45,060
You can get to auto sum by going to the Home tab, selecting auto sum from here

10
00:00:45,180 --> 00:00:50,050
and if you hover over it you see the shortcut key, Alt and the equal sign.

11
00:00:50,070 --> 00:00:56,400
Now if you also click on this dropdown here you can see other functions that are included in here that

12
00:00:56,400 --> 00:01:01,990
you can easily use. Since the shortcut key is the fastest way of getting this done.

13
00:01:02,010 --> 00:01:03,180
Let's use that.

14
00:01:03,180 --> 00:01:09,940
I'm going to highlight the area I want my results to be in first and then "Alt+=".

15
00:01:09,960 --> 00:01:10,830
That's it.

16
00:01:10,830 --> 00:01:17,040
I get my sum function in there and Excel smartly tries to figure out what the correct range is. In this

17
00:01:17,040 --> 00:01:24,210
case it's C5 to C12 and right here it's D5 to D12. Now to calculate the average

18
00:01:24,300 --> 00:01:31,350
of these, I can start off by typing in the average. I'm going to press the tab key to accept that first

19
00:01:31,350 --> 00:01:38,940
argument there and then I'm gonna give it the range I want to get the average of. And Excel automatically

20
00:01:39,030 --> 00:01:45,240
calculates the average of this range so you don't have to get the sum and then divide it by the count

21
00:01:45,240 --> 00:01:51,270
of these, it does it all for you. I'm going to drag this to the right or I'm just going to highlight this

22
00:01:51,600 --> 00:01:59,430
and use the shortcut key control+r to fill this to the right. If I click here I can see that the correct

23
00:01:59,520 --> 00:02:06,690
range has been highlighted. Now what if I want to sum values from different tables. I don't have one

24
00:02:06,690 --> 00:02:13,620
continuous range. So let's say here I have another table and I want to add these to that sum. So if

25
00:02:13,620 --> 00:02:22,740
I use auto sum right here, Excel things I just want to sum these. I don't, I want it sum these ones and

26
00:02:22,740 --> 00:02:29,580
sum these as well. And this is where you can use the argument separator and then I'm going to give

27
00:02:29,580 --> 00:02:31,490
it this range of cells, right.

28
00:02:31,500 --> 00:02:39,090
So it's summing these and these and the bracket is closed, press enter. Now for average it's the exact

29
00:02:39,090 --> 00:02:40,070
same thing.

30
00:02:40,200 --> 00:02:49,830
Type in average and again you can give it different ranges, close bracket, press enter. Now if you want to fill

31
00:02:49,830 --> 00:02:57,030
this to the right I'm just going to highlight these, what was the shortcut key? control+r just go here

32
00:02:57,030 --> 00:03:04,830
to double check. These are referencing the D column, these are referencing the D column as well. So that's

33
00:03:04,830 --> 00:03:09,060
how easy it is to use the sum and the average functions.