How to sum in excel? Excel summation formula

Drag and drop computing

1. As shown in the following figure, we only need to select the required and data in the same column, and the values of the data will be displayed in the excel status bar. Of course, the values can also be as follows:

2. After selecting the requirements and data, click the auto-sum icon in the menu bar, as shown in the following figure.

3. The automatic calculation has been completed, as shown in the figure below.

Formula input: sum () function

1. You only need to enter the table range you requested in the following title bar. For example, "= sum (d1: d4)" indicates the sum of the values in cells 1-4.

2. This method is also used for horizontal lattice calculation. Just enter the coordinates of the two cells, separated by a colon in the middle, and press enter.

Not in a sequence calculation

1. As shown in the following figure, the sum value is not in a row or a row, and the sum value is in the A5 cell. In this case, click the sum icon and press Ctrl, select all the numbers to be calculated with the mouse.

2. After you press enter, the selected data is automatically counted.