1. Need to sum the data, the format of the cell for the text format (or other non-arithmetic format).
2. Need to sum up the data in the cell where there is a merged cell.
Solution:
Select these data, right mouse button, set the cell format, change it to digital format, and then summing, can be.
2. Find the contents of the merged cell, take the merger (right mouse button, set the cell format, remove the merged cell before the hook), and then summing, you can.
Excel and method: in excel will be added to cell A1 and B1 cells and summing, summing up the results displayed in cell C1. First of all, we select the C1 cell, and then in the "Edit Bar" in the input "= A1 + B1", and then press the keyboard "Enter". Sum the results will be displayed in the "C1" cell.
Excel table will be multi-line or multi-column batch summation method: A column of data and B columns of data summation, the results will be displayed in the C column. First of all, we need to A1 and B1 two cells and sum. Select cell C1, in the "edit field" in the input "= A1 + B1", and then enter. Next, move the cursor to the lower right of the C1 cell until the cursor becomes a black cross, press the left mouse button and do not let go, drag to the bottom, at this time, A and B columns in the sum of the results are all displayed in the C column.