Which 8850 Form Totaling 2016-2023

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