Tip: If you want to sum multiple columns, you can also use the drag method to find the sum of other columns after you subtotal a column. the operating process steps, as shown in Figure 2:Ģ.

∑ icon), then the sum formula =SUM(D2:D10) is filled automatically into D11, press Enter on the keyboard, and sum of the clothing sales is subtotalled. Select cell D11, select the 'Formulas' tab, click the 'AutoSum' icon (i.e. If you want to subtotal the sum of clothing sales. After dragging to the last line, press Ctrl + S to save, it will be updated to the total score of the corresponding student.ġ. Tip: If you drag down the process, the cells that have passed do not become the total score of the corresponding student. The process steps are as shown in Figure 1:Ģ. ∑ icon) at the top left of the screen, then the sum formula =SUM(B2:D2) is filled automatically into the cell E2, press Enter on your keyboard, find the total score of the first student move the mouse to the cell fill handle on the lower right corner of E2, hold down the left button of mouse, drag down until the last row, then count the total of all students. Select cell E2, select the 'Formulas' tab, click the 'AutoSum' icon (i.e. If you want to count the total score of each student.

I, How to sum in excel method 1: Use the sum optionġ. In addition, there is a shortcut method of sum for multi-row or multi-column in batches, that is, simply select the cell corresponding to the row or column required to achieve the summation. You can sum a row or a column, or can also sum the specified ranges of cell at a time and it can sum multiple rows, columns, or multiple ranges of cell. In terms of convenience and speed, it is convenient and fast to use the sum shortcut keys rather than the sum option. One is to use the sum option provided by Excel, and the other is to use shortcut keys. There are two main methods for Excel sum. In Excel, sum the table is one of the normal operations, it is used much more.

How to sum a column in excel