Video instructions and help with filling out and completing Which 8850 Form Totaling

Instructions and Help about Which 8850 Form Totaling

Music hi I'm Ted and today I'm going to show you how to make a totaling column formula in Excel I have a spreadsheet already here and it's just some some information I made up and it's an imaginary list of employees and how many weeks they worked and how many hours per week they worked and then the over on the right I have a formula with the total hours which is just the weeks times the hours per week and what we want to do is we want to total up the total number of weeks that all the employees worked and the total hours that they all worked so what we're going to do is we're going to go to the bottom of the of the table and we're going to add a new column and we're going to we're going to call it total and we're going to in cell b12 we're going to have the total we're going to enter in a formula and the easiest way to do it is to use the sum formula obviously we could we could put in a formula and we could say equals B 2 + B 3 + B 4 + B 5 but that could get very tedious and Excel has ways to make things like this common tasks that you do much simpler so we could go in and we could say equals sum s um and then an open parenthesis and and then just select the whole range of cells we want to add and then close the parentheses and and hit a return and when we do that I guarantee we'll have the sum at the bottom but I'm going to show you a much quicker way of doing it and so I'm going to hit the up here I'm going to cancel what I was going to do hit the little red X up there and I'm going to show you a shortcut that Excel has and depending on the computer you have in the particular operating system in the version of Excel you may find it in a different place but you want to look for a symbol that looks like this which is the Greek capital Sigma sign and it's the universal symbol symbol in math for summation so you look for that and if you mouse over it it says display the sum of the selected cells at the end of the selection now this is really cool because when you do we're going to click on that and watch what happens Excel knows that we have a range of numbers that are adjacent to the place where we're entering in the sum formula and it's already picked out the cells exactly the way we want it so we hit return and we're done now let me just show you if we happen to have a blank line in there so I'm going to insert a blank line and it sort of row and we're going to go over here and we're going to put do try the same thing over here in column D where we have the total hours and let's try that little trick I just taught you click on the sum sign and look what happened it only wants to sum the cells up to where that blank line is so that's why it's very important in Excel when you're do going to do lots of things like this is to have a consistent pattern to your to your your cells you don't want a lot of blank lines because Excel doesn't like that when it's doing things like this so let's let's undo that and and we'll click on the undo lines so that we we do we don't have that blank line and let's just go down here and click on the sum sign hit return and we're done and then you might want to do some formatting I always like to have a bull you know the totals bold so it so that they stand out and you can do all kinds of formatting yourself for whatever whatever it is you want to show so I hope this has been helpful I'm Ted and today I showed you how to enter in a totaling column formula in Excel thank you for watching Music