MS Excel is designed to work with spreadsheets. This application is very convenient to use for performing various types of calculations using built-in functions and formulas. In addition to the simplest calculations of addition, division, multiplication and subtraction, the program is capable of calculating using financial and logical functions.
It is necessary
MS Excel program
Instructions
Step 1
Start MS Excel to add the cells. Set the number or currency format for the cells in which you will enter numbers. To do this, select a range of cells, right-click and select the Format Cells option. Or select the "Format" menu and the "Cells" item. Go to the "Number" tab and select the desired cell format. Set the required number of decimal places and click "OK".
Step 2
Enter the required data in the cells to determine the sum of numbers in Excel. To enter the same or increasing by an order of magnitude (for example, 10, 12, 14) use the "AutoFill" function. If you need to calculate the sum of cells in one column or row, and display the result in the last cell, select the data column and click on the "AutoSum" button on the toolbar.
Step 3
Calculate the sum of values in Excel cells using the "Function Wizard". To do this, select the cell in which you want to get the result, enter the "Equals" sign. Click on the "Function Wizard" button on the toolbar. Select Sum or Sum from the list of functions.
Step 4
In the window that opens, click on the button to the right of the "Number" field and select a range of cells, or enter it in this field and click on the "OK" button. The range is entered in the following format: for example, to sum the cells from A1 to A19, enter them separated by colons. To add up two ranges, enclose them in parentheses and put a plus sign between them.
Step 5
Click OK. The function can be added manually, for this, in the required cell, enter the sign "Equal", write Sum or "Sum", depending on the version of the program. Next, select the range of cells and press Enter.
Step 6
Calculate the sum in cells if the numbers are in different places in the table and cannot be combined with one range. In the cell where you want to get the result, enter the equal sign. Next, select the first cell to enter a link to it in the formula, put the plus sign, select the next cell, plus again. Select the required cells in sequence and click Enter.
