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.
#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;
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;
3. Then the first condition of the subtotal function selects the number 9, which means sum is used for summing;
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;
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;
#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.
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!