Advice 1: As for excel to take a number

The operation of subtraction in the table editor Microsoft Office Excel can be applied to two particular numbers, or to specific cells. In addition, it is possible to subtract the appropriate values from all cells in a column, row or other area of the spreadsheet. This operation can be part of any formulas or herself to include functions that calculate and minuend minuend value.
As for excel to take a number
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
Click the table cell in which you want to get the result. If you just want to find the difference between two numbers, first give the table editor to know that in this cell the formula is placed. To do this, press the equal sign. Then enter the minuend number, put a minus and type the subtrahend. The full entry can look like this: =145-71. Press Enter to let Excel that the input formula is finished, and the table editor will display in the cell the difference between the entered numbers.
2
Optionally, instead of the specific values to use as deductible, reducing both numbers, or the contents of some table cells, use the formula to them. For Example: =A5-B17. Links can be entered from the keyboard, or clicking the mouse on the required cell - Excel will determine her address and put in the dial equation. In this case, finish the input by pressing Enter.
3
Sometimes it is necessary to subtract some number from each cell column, row, or a certain area of the table. To do this, place the subtrahend the number in a single cell and copy it. Then select in the table the range column, row, or even several disjoint groups of cells. Click with the right mouse button on the selected area, the shortcut menu, navigate to "paste Special" and select the item called "paste Special". Check the box labelled "deduct" in section "Operation" of the window that opens, and click OK - Excel will save the values of all selected cells to the copied number.
4
In some cases it is more convenient to use functions instead of entering operations of subtraction, for example, when the subtrahend or the minuend must be calculated by some formula. Excel has no special functions for subtraction, but it is possible to use the opposite - "AMOUNTS". Call the form with its variables, selecting a row with its name in the drop-down list of "Mathematical groups" teams "Library functions" on the Formulas tab. In the "Number1" enter minuend value or a reference to the cell that contains it. In the field "Number2", type -1, and then enter the subtrahend number, cell reference or formula. If necessary, do the same with the subsequent lines, they will be added to the form as you fill your blank fields. Then click OK, and Excel will do the rest.

Advice 2 : As in excel to do the sum

Often when processing data in spreadsheets required, the operation of calculating the sum in any column, row, or selected group of cells. For these operations in the table editor Microsoft Office Excel is a function called "autosummary". In addition to simple addition of the values of this operation you can specify more complex conditions.
As in excel to do the sum
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
For a simple summation of the data in any column of the table click on the cell below the last row of this column. Then go to the Formulas tab in the menu of the table editor and click "AutoSum" in group "Library of functions". Excel will place the desired function in the selected cell, include it in the formula edit mode and try to determine the range of summation. Make sure that 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 the sum column is blank lines - Excel can not "jump over" them yourself. If the region of summation are correct, press Enter, the editor will calculate and display the sum.
2
In the summation of row values, all of the above have to do with the cell located to the right of the last column to sum the range.
3
If you want to add up all the values of a certain area of the table including the rows and columns, first set the input cursor in the cell where you display the result. Click the same label "AutoSum" on the Formulas tab, and then the mouse will select the area of the table. This is the easiest way to specify a range, but you can do it manually by first dialing the address of the upper-left cell of the range, then put a colon and adding the address of the lower right cell. Anyway, specifying the field to sum and press Enter - the result will be calculated and displayed by the editor.
4
Excel allows to use more complex variants of this operation - for example, you can specify a condition under which the program will be selected for summation of cells from a specified range. To do this, select the cell to display the result in the command group "function Library" tab, "Formulas" open the drop-down list of "Mathematical" is the middle button in the right column of icons. Select in the list the function "SUMIF" and Excel will open with a form to enter its parameters.
5
Click the field "Range" and then with the mouse select the area of the search these cells. Under criteria, specify the criteria that must be met by selected cells - for example, summing only positive values, type >0.
6
Press Enter, and the summation operation on the condition will be met.
Is the advice useful?
Search