Drag the mouse in Excel, select the data to be calculated, and use "AutoSum" in the menu bar to get the result. Or select the table where you want to output the results, enter the summation formula in the edit bar, the format is "=SUM (start cell: end cell)", and you can get the result.
The specific steps are as follows:
#1. Use the automatic sum in the Excel menu bar
1. Drag the mouse to select the data to be calculated. As shown in the picture:
#2. Click [Autosum icon] in the menu bar. As shown in the picture:
#3. Next, the sum calculation will be automatically completed. As shown in the figure:
2. Use the summation formula SUM
1. Select the table to output the results . Enter the summation formula in the edit bar in the format "=SUM(E1:E5)". As shown in the picture:
The result is as follows:
3. The horizontal grid calculation method is the same as the vertical grid calculation method. Select the horizontal calculation range and then select automatic sum or enter the calculation formula to get the result.
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to total in excel. For more information, please follow other related articles on the PHP Chinese website!