Excel 2010 Manual Batch sum all Raiders

Sometimes we want to add or multiply some data in Excel to derive its sum or product. In Excel, it is very convenient and accurate to sum up or to ask for a difference. This time Word federation will explain in detail how to use Excel2010 batch summation method.

Excel2010 a single summation method:

As the following illustration shows, I want to add A1 and B1.

① first of all, we have to find an open space, to put together the results, choose C1 Bar, add A1 and B1 the results of the added in the C1 (mouse click to select C1 cell);

Excel Tutorials

② Select C1, enter "=A1+B1" in the "formula bar";(the following figure)

③ Then, press "enter" on the keyboard and the result we want is already in the C1 cell.

Excel2010 Batch Summation method:

And then, above, we're talking about a single sum, and then we'll talk about how to sum them in batches, from A1 to A11 and B1 to B11, and then the results are shown in C1 to C11 cells.

① first of all, we have to first find a single and, the results will be placed in the C1. That is to say, the first step in batch summation is all the steps of a single sum;

② move the cursor to the lower-right corner of the C1 cell until the mouse becomes a "black cross" shape, holding down the left mouse button until the C11 cell is released;

OK, the result from A1 to A11 and B1 to B11 is already in C1 to C11 cell, is it very convenient!