Home  >  Article  >  Topics  >  How to total in excel

How to total in excel

尚
Original
2019-06-12 14:38:026999browse

How to total in excel

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:

How to total in excel

#2. Click [Autosum icon] in the menu bar. As shown in the picture:

How to total in excel

#3. Next, the sum calculation will be automatically completed. As shown in the figure:

How to total in excel

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:

a044ad345982b2b7eb492a883fadcbef77099baHow to total in excel

The result is as follows:

How to total in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn