In the use of Excel, we can use the excel summation function, can greatly enhance the efficiency of our work, the specific methods used are as follows:

(1) how to seek out data and. To assume that cell A2 to A6 of the data and fill in A7 cells, the operation is as follows:

First selected cell A7, double-click the Edit column “=”, then double-click the toolbar】 【common summation symbol “Σ”; then use the mouse to click the cell B2 and has been drag to B5, the election B2_B5 in the whole region, then in the edit field and B6 can be seen from the formula “= sum (B2: B5)”, click the Edit column “√” (or press Enter button) to confirm that, the formula to establish the end. At this point B2 to B5 in the cell of arbitrary input data, and immediately they will appear in the cells in B6.

(2) how to seek and peer data. If you want cell B2 to D2 and enter the data in cell E2, is similar, but attention should be paid to horizontal operation: the establishment of the cell formula (the case of E2) 【unit must Format Cells dialog box】 【】 to select the level of alignment “conventional” manner, so that the cell shown in the formula will not affect the next cell.

(3) how to seek a separate line (or column) of data and. If you want cell B2, C5 and D4 of the data and fill in E6, the operation is as follows:

First selected cell E6, double-click the Edit column “=”, then double-click the toolbar】 【common summation symbol “Σ”; then click the cell B2, type a comma “,” and click C5, type “,”, and then click the D4, then in the edit field and E6 can see the formula “= sum (B2, C5, D4)” confirmed that the establishment of finished formula.

Between two tables in the summation

Assume that n Zhang and schedule the same table format, if the location of these tables the same cell (for example, B2) all the data in aggregate, the results will fill in another form of B2 the same format, the operation is as follows:
Summary of the first selected cell B2, double-click the Edit column “=”, then double-click the toolbar】 【common summation symbol “Σ”; then click the tab Table 1, do not hold down the Shift Kin release, then click the tab Table n (Note: the tables have been aggregated should be included in tables 1 and between the location of n), release the Shift and click the cell Kin B2, this can be seen in the editorial column to the formula “= sum ( ‘Table 1: Table n’! B2)”, confirmed that the establishment of finished formula.

If you want table 1 to table n the corresponding cells to aggregate all the data in the corresponding matrix to the cell, you can use methods similar to Example 1, a one-time selection of the B2 matrix to the entire E6 rectangular area, the original cell B2 in the formula to create a copy from.

4 If the number of cases to vary the format of the table data (for example, Table 1 B3, Table 2 of the C5, Table 3 of the D3, Table 4, E4 … …) Summary table to another in cell B2, operation are as follows:

Summary of the first selected cell B2, double-click the Edit column “=”, then double-click the toolbar】 【common summation symbol “Σ”; then click the tab Table 1, and then click its cell B3, type “,”, and then click the tab Table 2 and its cell C5, type “,” … … and so on for each of the table tag and the selected cell 11, the final table after the cell type, “”, then edit the column appears in the formula is: “= sum (Table 1! B3, Table 2! C5, Table 3! D3, Table 4! E4 … …)”, confirmed formula to establish the end.