1, click the sum continuously.
On the page of excel, click a blank cell at will, and then enter an equal sign. When you are finished, click the first number, enter a plus sign, and then click the second number. After clicking the status difference, press the Enter key on the keyboard, and the sum can be successful.
2. Automatic summation
On the page of excel, find the formula option at the top, click it, and a window will pop up. In the formula window, find the automatic summation option and click. Then use the mouse to select several numbers that require sum, and press Enter to sum successfully.
3, insert function summation
On the page of excel, click any blank cell, and then click the formula above. In the formula window, click the Insert Function option to open the function window. In the window where the function is inserted, click the input box above, enter the total, and then click Start. Finally, in the selection function below, click sum, and then click OK at the bottom of the window. Then use the mouse to select the number you want to sum, find OK in the window and click, and you can sum successfully.
Excel other summation methods:
1, single conditional sum: sumif function
The 1 th parameter of the sumif function is: conditional region; The second parameter is: summation condition; Press Enter to calculate the sum of more than 2000.
2. Multi-conditional summation: sumifs function
The 1 th parameter of the sumifs function is: summation region; The second and fourth parameters are: conditional area; The third and fifth parameters are: summation condition; Press Enter to complete the confirmation, and the amount of more than 2000 and more than 200 can be settled.
3. Cross-table summation: tables
In the function formula, the parameter of the Sheet function is: 1 month, and in March, B2 represents the sum of B2 cells in the three worksheets from 1 month to March.
4. Shortcut summary: Ctrl+=
Simply select the summation area and press the shortcut key Ctrl+= to calculate the sum of the summation areas.