 Hello everyone and welcome back to another tutorial in this video We're going to be answering the question of how to add in Excel So we're going to cover over a real quick simple way of how you can add two numbers together and just show you Obviously a quicker way to do that using a function we have built into the into Excel itself If you haven't already please take this opportunity to subscribe to the channel when you do so hit that bell Notification button just to the side of the subscribe button So you're notified of all of our future videos as they come out So how to add an Excel? Well the two primary ways and we'll start with the basic is In our example we have here We've got a simple table that shows the month down the left-hand side and we can see for 2018 and 2019 We've got some we've got a number of sales per month Admittedly we are only in October at point of recording. So if you see numbers here from November and December Don't worry about those. It's just for example purposes anyway So in the scenario that we wanted to just add 2018 and 2019 together so we could see for the month of January. What's the total sales we've had? Across those two years Probably not a scenario that you're wanting to do but it just helps demonstrate with two numbers We can simply add two together by doing our equal symbol and then selecting our first number Which is in the cell reference C6 Holding down shift and finding our plus button on our keyboards and then selecting the second number of 19 here Enter and you can see that you've got the total of those two numbers combined And if you want to that all the way down our table All you need to do is hover over the corner of the cell where you'll see this black square has appeared When you hover over there, you'll see you get a black crosshair You can just sort see slightly how the mouse changes as you hover over that corner and Just drag that down and you can see that that has populated the total for those two numbers for each Corresponding row so that's one way that we can do the addition and I was going to clear that just so we can start from fresh When it comes down to totaling a number or more than just one or two numbers Well, not more obviously more than one with two or more numbers Obviously, we have another option available to us So rather than going and following our first example of doing First number plus second number plus third number as you could do We can simply replace this by just doing equals and then typing the word sum and then opening brackets So by typing in some as we've done here in the open brackets We're now using the sum function that we have available to us in Excel So in order to use this all we now need to do is rather than using the plus symbol between every number All we need to do is select the starting point or the first row that contains the numbers We want to add together click and drag so we highlight all of those cells And then we can close our brackets by doing hold down shift and the number zero So your formula will look like this at the bottom here or you can see it better there in the formula bar Once you've done that just hit enter and you can see we now get a total for that full range If you want to extend that further to this next column all we need to do again Is drag that bottom right corner across and you can see the total sort of added and the real benefit of using this as If we did the additional sum or use the individual additions If we remove some of the numbers you can see that the total is automatically updated for us as well So this is why using when you're using totals. It's key to keep a formula in there So it's constantly dynamic and updating as your data changes So we hope you found that interesting and that gives you an answer to your question on how You can add your two numbers together or use the sum function And it's also worth just mentioning actually going back to our first example You can actually even use the sum function with just two numbers as well if you wish there is no limitation on the range size It's just obviously you don't really need to use a function if you're just doing the two numbers But again, I hope you found that video interesting if you haven't already Please do subscribe to the channel hit that bell notification buttons You're notified of any of our videos as soon as they come available on the channel If you could as well if you did enjoy the video, please do give it a like It's not only appreciated by us And obviously shows us the content that you like to see and want to see more of but it's obviously also going to be Beneficial to the channel to help with that YouTube algorithm. So lastly, thank you very much for watching and we shall see you in the next video Before you go don't forget to check out the other videos on our channel You'll see everything from other functions and formulas through to tips and tricks We've also created some playlists so you can see these categorized together So make sure you check those out and get all those useful information And obviously as always don't forget to subscribe and hit that bell notification button