Most often, when processing data in spreadsheets, the operation of calculating the amount in a column, row or selected group of cells is required. For these operations in the spreadsheet editor Microsoft Office Excel there is a function called "auto-summing". In addition to simple addition of the values of this operation, you can specify more complex conditions.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
For a simple summation of data in any column of the table, click on the cell located under the last row of this column. Then go to the Formulas tab in the spreadsheet editor menu and click on the AutoSum label in the Function Library command group. Excel will place the desired function in the selected cell, turn on the formula editing mode in it, and try to determine the summation range on its own. Make sure he was not mistaken - check the correctness of the first and last cells, and if necessary, make changes. Such a need may arise, for example, if there are blank lines in a summarized column - Excel cannot "jump" over them on its own. If the summation area is specified correctly, press Enter - the editor will calculate and display the amount.
Step 2
When summing row values, everything described above must be done with the cell located to the right of the last column of the summed range.
Step 3
If you need to add all the values of a certain area of the table, including both rows and columns, first place the cursor in the cell where you want to display the result. Click on the same AutoSum label on the Formulas tab, and then select the required area of the table with the mouse. This is the easiest way to specify a range, but you can also do it manually by typing first the address of the upper left cell of the range, then placing a colon and adding the address of the lower right cell. One way or another, after specifying the coordinates of the area to be summed, press Enter - the result will be calculated and displayed by the editor.
Step 4
Excel allows you to use more complex versions of this operation - for example, you can set a condition by which the program will select cells from a specified range for summation. To do this, select a cell for outputting the result and in the "Function Library" group of the "Formulas" tab, open the "Math" drop-down list - this is the middle button in the right column of icons. Select the "SUMIF" function in the list and Excel will open a form for entering its parameters.
Step 5
Click the "Range" field, and then select the search area for the cells to be summed with the mouse. In the criterion box, specify the condition that the selected cells must satisfy - for example, to sum only positive values, enter> 0.
Step 6
Press Enter and the conditional sum will be performed.
