In the daily office, we sometimes need to sum the data in excel columns, the general method is to select the columns that need to be summed one by one, but if there is more data to be added, it is easy to miss the data and is very slow, so how can we quickly sum the data in excel columns?Let's share the operation method with you. Excel Tips
Methodological steps
1. Open Excel**, create auxiliary rows in the blank row corresponding to **, and enter 1 and 2 in the first two cells, then select the two cells and drag them to the right to fill, and then clickAutofill Options - Copy Cells, copy padding 1 and 2.
2. Enter the function in the ** sum cell:=sumif($b$10:$g$10,"1",b2:g2)Then press the [Enter] keyto get the sum of each other column of data.
Note: Description of the function formula.
B$10: $g$10]: refers to B10: G10Secondary row data regionPress F4 once for absolute reference
1"]: Refers toThe number 1 of the auxiliary row；(If you ask for 2, choose 2).
b2:g2]: Refers to**All data regions in the first row
3. Select the cell to enter the formula, and move the mouse to the lower right corner of the cellWhen the cursor changes to a black + sign, drag the fill down, so that the sum of the next column is complete.
4. Select all the summed data areas and press【ctrl+c】Copy, and then right-click to selectPaste Options - Values, convert the formula to a normal value, and then delete the auxiliary rows without affecting the data.
5. If yesSum every column:If the sum is separated by two columns, enter 1 and 0 and 0 in the first three cells of the auxiliary row, and copy the fill to the right, and the other methods are the same. If you sum every three columns, the auxiliary columns are the first four cells 1,0,0,0, and so on.