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 information I made up. It's an imaginary list of employees, how many weeks they worked, and how many hours per week they worked. Then, on the right, I have a formula with the total hours, which is just the weeks times the hours per week. What we want to do is 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 go to the bottom of the table, add a new column, and call it "Total." In cell B12, we're going to have the total. We're going to enter a formula, and the easiest way to do it is to use the "SUM" formula. Obviously, we could put in a formula and say equals B2 + B3 + B4 + B5, but that could get tedious. Excel has ways to make tasks like this simpler. We could go in and say equals SUM, and then open parentheses, select the range of cells we want to add, close the parentheses, and hit return. When we do that, I guarantee we'll have the sum at the bottom. However, I'm going to show you a quicker way of doing it. I'm going to hit the little red X up there and show you a shortcut that Excel has. Depending on your computer, operating system, and version of Excel, you may find it in a different place. Look for a symbol that looks like the Greek capital Sigma sign, which is the universal symbol in math for summation. If you mouse over it, it says "display the...
Award-winning PDF software
Video instructions and help with filling out and completing Which 8850 Form Totaling
