Notice how the cells included in the formula are highlighted - this is a useful way to check whether your formula is using the correct range of cells for its calculations. If we look at our earlier example, you could use SUM() as shown in the following formula, which would achieve the same result as our earlier example: It is particularly powerful because it can be used to write a simple formula add up hundreds or thousands of cells. The SUM() function will then add up the values in all the cells from the start to the end of the range. However, it also allows you to add up a range of cells simply by specifying the first and last cell in a range of cells to be added up. It can be used to add up individual cells, as we did in the last example. The SUM() function is a much more efficient way to add up cells. Option Two - use the SUM() function to add up a range of cells For that reason, you may prefer the next method of adding up cells in Excel, which uses a function to do the addition for you. Of course, this approach to adding up cells becomes difficult to manage once you have a large number of cells to be added. This will create the same formula as shown in the example above without you needing to manually type the whole formula. Repeat until all cells to be added have been clicked.Type + again, and the next cell to be added.] Click on the second cell to be added (A3 in this example).Click on the first cell to be added (B2 in this example).Type = (press the equals key to start writing your formula) Click on the cell where you want the result of the calculation to appear.Any time you change one of the values in cells B2, B3, B4, B5 or B6, the value in B8 will change immediately to show the correct sum of these cells.Ī faster way to add up the values in several cell is to follow these steps:
The great thing about adding up cells in this way is that the formula will always show the current value of the sum of these cells. Note that if one or more of the cells are empty, or contain text rather than a number, Excel will simply ignore those values when calculating the result.Īlso note that Excel doesn't mind if you type the formula in lower case as shown below - Excel will automatically convert each letter to uppercase when you press Enter: When I press Enter, the formula will be stored in the cell, and the result of the formula will be displayed as shown in the example below: Notice how the cells in my formula have been highlighted as I typed my formula: In this example, I've started typing the formula into cell B6. You can add up the values for Monday to Friday (from cell B2 through to B6) by typing the following formula into another cell in your spreadsheet. Let's say you have several cells that contain numbers, and you would like to add those numbers together:
This lesson shows you several methods including the SUM function and the Autosum button. There are a variety of ways to add up the numbers found in two or more cells in Excel.
0 kommentar(er)
