How to total data using excel table?

How to use excel table to total data: 1. Open the data file to be processed; 2. Drag the mouse to select the data to be calculated; 3. Click the [Auto Sum Icon] button in the menu bar. .

How to use excel table to total data:

1. First, open the file to process the data File;

2. We have the corresponding numbers in the excel table. We drag the mouse to select the data to be calculated. As shown in the picture;

#3. In the menu bar, we click [Auto Sum Icon]. As shown in the figure;

#4. Next, the sum calculation will be automatically completed. As shown in the figure;

#5. Select the table to output the results. Enter the summation formula in the title bar in the format "=sum(E1:E5)". As shown in the figure;

#6. After the settings are entered, let’s look at the calculated results. As shown in the picture

# Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to total data using excel table?. For more information, please follow other related articles on the PHP Chinese website!