Add Additional Formula with airSlate SignNow

Generate columns record

[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...