How to add in Excel
A Tutorial on how to add in Microsoft Excel.
Numbers in Excel can be added in several ways including:
- Typing in the numbers and formula all at once for simple additions
- Adding together numbers in existing cells by typing a formula
- Adding numbers in cells by clicking the Insert Function (fx) button and clicking SUM
- Adding numbers in cells by clicking the Autosum function from the formulas menu.
The first method can be accomplished by clicking a Cell and typing the = sign followed by the first number you want to add followed by the + sign and the second number you want to add followed by another + sign and another number for as many numbers as you want. Example: =9+5+7.
The = sign should not be entered at the end of a formula.
The second method can be accomplished by typing the = sign followed by the command SUM followed by the cell references for the numbers enclosed in parentheses. Example: =SUM(B2:B8) You can select the cells you want to add together by dragging your cursor over them with your left mouse bun once you type the open parentheses ( symbol.
The third method – which is easier – is to click the cell beneath column of number you want to add then selecting the functions (fx) button and clicking the SUM function. Excel should automatically select the range of cells above the cell where the formula is inserted and you should be able to just click the OK button to confirm the selection.
The fourth method – which you might find to be the easiest – is to click the cell beneath column of number you want to add and then selecting AutoSum button on the editing tab or click the Formulas tab at the top of the Excel program and click AutoSum. It will automatically add together the vales of the cell above the AutoSum formula.
The best way to learn is to actually enter the data and formulas yourself.
In the first row and first column (A1) double click on the cell with your left mouse button and type =9+5+7
Now hit the small check mark icon √ on the formula bar and it should give the result of 21. You can also complete the action by hitting the enter key on your keyboard. If you click on the cell the formula used to perform the function should appear in the formula bar while the result of the calculation should appear in the cell.
For the second example type the number 9 in the second column of the first row (B1) and type the number 5 in cell B2 and the number 7 in cell B3. In cell B4 we’ll type a formula. Double-click on cell B4 and type =SUM( and then select cells B1 through B3 by holding down the left mouse button and dragging the cursor down until all three cells are highlighted. Hit the enter key on your keyboard to complete the formula or click the check mark √ on the formula bar.
Click the image below to see all four methods being used.