Tutorial on batch sum of multiple rows or columns in Excel

Step 1. After opening the Excel table, we will add and sum the data in column A and the data in column B. We will put the result of the sum into column C.

Step 2. Then we will add and sum the A1 and B1 cells. Then, enter "= A1 + B1" in "edit bar" in C1, and press enter.

Step 3: Move the cursor to the lower-right corner of cell C1 until the cursor turns to a black cross. Press the left mouse button and drag it to the bottom;

Step 4: the result of this sum is all displayed in column C.

Well, we will introduce the batch sum operation method for multiple rows or columns. In fact, it is very simple. In this case, we will refer to column C as A + B = C, like other algorithms, it is very simple and easy.