Introduction to Excel Summation counting technique
such as serial numbers, 1, 2, 3, 4, 5 ... In particular, the number of more error-prone, not to mention the possibility of row in the middle of the deletion added. In particular, some tables are multiline merges, for example, in our case, there are two lines of merging, and there are three rows of merged, simple pull down drag does not complete the bulk Add. At this point, you can use the =max formula, specifically =max (A$1:A1) +1 (note the use of the $ parameter), note that when you enter a formula do not return directly, but press CTRL + ENTER, so that you can achieve bulk population.
Similarly, in our example, the data structure of the total data column, to calculate the sum of each group, this process, to use the =sum formula, specifically =sum (d2:d$9)-sum (e3:e$9), the same is to press CTRL + ENTER to take effect. Note that when you enter a formula, our D column uses the $ parameter to absolutely reference the fixed area, so that the data is correct.
The last is our number of statistics, examples of each of the number of organizations and fewer, to use a formula to make all the numbers automatically calculated, and not to separate the group input formula, can be implemented with =counta, specifically =counta (c2:c$9)-sum (f3:f$9), press CTRL + Enter to take effect. Similarly, also in the F column using the $ parameter is fixed.
As a result, all the data can be merged or not, each column can be a formula to solve the problem, and not because of the wrong ranks of the error caused by the table statistics, and greatly improve the efficiency.