How Excel tutorials Implement multiple-column data summation

Today's tutorial just solves the problem, and if you want to know what to do, take a look at the following specific procedures:

① first starts Excel2007, open the table containing data, 12 months of data in a year, we need to sum 2 columns, such as three or six, 92 or 12, talking about the sum, function formula is essential, we do not fear these, in the M2 cell enter the formula in the following figure, to make an interval of 2 columns sum.

② input complete, return to get results 223, double-click the cell in the lower right corner of the fill handle, automatically calculate the rest of the data.

③ below, we verify that the function formula calculates the correct, the 9th row three or six, 92 or 12 4 months of data in yellow color, hold down the CTRL key selected, in the status bar below can see the sum of 259, to prove that our formula calculation accuracy.

The ④ formula in the argument 3, is 2 columns, 2 columns 3, 3 columns is 4, every 4 column is 5, and so on.

Formula description

Because every 2 columns are summed, that is, 2, 6, 9, 12 ... column, so the MoD function is used to determine whether the remainder of the column number and 3 is 0, if so, return True (1), or return False (0), and then return the sum of the product of the array a2:l2 with the Sumproduct function.