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)
