How to automatic summation in Excel
We can use Excel in quick summation (automatic summation) function, can greatly improve our work efficiency, the use of specific methods are as follows:
(1) how to seek out the data and the same. To assume that cell A2 to the data of the A6 and A7 fill in the cells, operating as follows:
First selected cell A7, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click with your mouse cells B2 and has been drag to B5, election B2_B5 in the entire region, then in the edit field and B6 can be seen in the formula “= sum (B2: B5)”, click Edit column “√” (or press the Enter key) confirmed that the formula for the establishment of the end. At this point if the B2 to B5 cells indiscriminate importation of data, and immediately they will appear in a cell in the B6.
(2) how to seek data and peer. If you want to D2 cell B2 to the data and fill in the cell E2, is also a similar operation, but the cross-cutting operation to note: The formula for the establishment of the cell (in the case of the E2) must be in the [unit Grid format] [in the dialogue box, select the level of alignment - “conventional” methods, such cells appear in the formula will not affect next to the cells.
(3) how to seek a separate line (or out) and data. If the cell to B2, C5 and the D4 in the data and fill in the E6, the operation is as follows:
First selected cell E6, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the cell B2, type in a comma, “”, and click C5, type “,” and then click D4, then in the edit field and E6 can be seen in the formula “= sum (B2, C5, D4)” formula that is confirmed after completion of the establishment.
In summation between the two tables
N-the assumption that the same format and the schedule table, if these should form the same location cells (for example, B2) of all aggregated data, the results will fill in another form of the same format B2, the operation is as follows:
Summary of the first selected cell B2, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the tab Table 1, do not hold down the Shift - Fang, then click the tab table n (Note: The summary of the tables should be included in tables 1 and the location between n), after the release Shift-click the cell B2, at this time can be seen in the editorial column To the formula “= sum ( ‘Table 1: Table n’! B2)”, confirmed after the completion of the establishment of the formula.
If you want to Form 1 to Form n the corresponding cells to aggregate all the data summary table in the corresponding cells to, you can use an approach similar cases, one-time summary of the B2 selected E6 to the entire rectangular area, In the original cell has been established in the B2 copied a formula.
If the four cases to several different formats of data in the table (for example, Table 1 B3, Table 2 of the C5, Table 3 of the D3, Table 4 of the E4……) to another table summary of the cell B2, Operation are as follows:
Summary of the first selected cell B2, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the tab Table 1, then click the Cell B3, type “,” and then click the tab Table 2 and its cell C5, type “,”…… and so on, each of the labels and selected cell on January 1, the final table After the cells do not type “,” At this time in the editorial column of the formula is: “= sum (Table 1! B3, Table 2! C5, Table 3! D3, Table 4! E4……)”, after confirmation Established formula that is finished.
Can not be wrong for peace
As the operation in the field of numerical changes, the summation of the field all cells did not result in changes in values, resulting in normal operation. You can click on “Tools → Options” orders, opened in the “Options” dialog box, click the “re-calculation” tab. “Calculated” option in selected areas “automatically be” radio button, click “OK” button, can automatically calculate and update cell values.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Anybody know how to auto fill text by typing a letter in a cell having text onto another worksheet(personal data names)?
thanks
munix