Home > Topics > excel > How to total the total in the table

How to total the total in the table

藏色散人
Release: 2020-07-11 11:21:51
Original
32410 people have browsed it

Method for totaling the total in the table: first sum the cell data at the end, and insert the subtotal function in cell B14; then select the number 9 for the first condition; then sum the area for the second condition Select B2 to B13; finally press the enter key to sum.

How to total the total in the table

#You can use the SUBTOTAL function to total automatically filtered data.

Recommended: "Excel Tutorial"

1. Take the excel2010 version as an example, as shown in the figure below, there is a data table;

How to total the total in the table

2. First, sum at the end of the cell data. For example, insert the subtotal function in cell B14, which means returning a data list or a classification summary of the database;

How to total the total in the table

3. Then the first condition of the subtotal function selects the number 9, which means sum is used for summing;

How to total the total in the table

4. Then the second condition is The sum range selects B2 to B13 to represent the data of this entire column in the sum table;

How to total the total in the table

5. Press the enter key to calculate all the data between B2 and B13. , pull the formula to the right to fill in, and find the sum of the data in other columns;

How to total the total in the table

#6. When filtering the table, for example, filtering the month, You will see that the data in one row is only the sum of the data displayed after filtering, and the hidden data is not summed together.

How to total the total in the table

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

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template