How excel only calculates the total of filtered numbers

After filtering, under the lowest row of the data column, press alt++ and the totals will appear. At this time, you can filter the range values of this data column, and the following total results will change.

If the data is in column A, it is required to sum the screening results with a score greater than 60. It can be entered in B1.

subtotal(109,a2:a8)

Press: xq1850 prompts, after you filter the total value of which column is counted, press it under which column"alt" + "+"(Hold down the alt key, press the " " key again, and then press enter.)

Filter out the first row.,It's been a year since I graduated.,It's almost a year since I used these features.,Anyway, those functions are public.。 Don't understand your question: Show 25, but don't count 25 in total? That's it.

Take the WPS 2019 version as an example:

1. Open the Excel document;

2. Select the data area you want to filter and click Data-Auto Filter;

3. In the filter setting pop-up window, check Advanced Mode to turn on the filter counting mode (Hint, this function needs to be used by WPS members).

If you want to search data from a file and filter out certain numbers that are equal to a certain number in total, you can use "Solver" under the "Data" option.

Example: If there are 10 numbers in cell A1:A10, you need to find out which cells are added to the target value 215 66, the specific steps are as follows:

Step 1: Enter sumProduct in cell B11 (A1:A10, B1:B10).

Step 2: In the "Solver" under the "Data" option, take b11 as the target cell, the target value is 215 66, the variable cell is b1:b10, and the constraint for adding the variable cell is:

b1: b10 is an integer; B1: B10 is the two-entry Sun calendar system (i.e., 0 or 1), solved;

Step 3: This is done, you can determine the solution result of the plan, and if it is satisfied, keep the result.

You can use the subtotal function to aggregate the automatically filtered data.

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

2. First, the sum at the end of the cell data, such as inserting the subtotal function in the b14 cell, refers to the return of a data list or the classification summary of the database;

3. Then the first condition of the subtotal function selects the number 9, which means sum to be summed;

4. Then select B2 to B13 in the second conditional summation area, which represents the data of the whole column in the summation table;

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

6. At this time, when filtering **, for example, filtering the month, you will see that the data in the total row is only the sum of the data displayed after filtering, and the hidden data is not summed together.

The steps for the total number of totals that are automatically filtered in an excel sheet are as follows:

The materials we need to prepare are: computer, excel**.

1. First of all, we open the required excel**.

2. Then the last cell of our cell data is input =subtotal(9,b2:b13), and then press enter to confirm.

3. Then we pull the formula to the right to fill in and find the sum of the data in other columns, and then it will be automatically summed after filtering.

1. After opening Excel, I see that there are two columns of data here, assuming that we need to filter out data greater than 3500.

2. Select the data you want to filter first, or select the data of the entire document.

3. Click Conditional Formatting under the menu bar.

4. Then click the Sudden Change button to display the large core under the cell specification.

5. On the pop-up window, enter 3500 and click the OK button.

6. After clicking on the bright bar, you can see that all the data greater than 3500 in the document is displayed in the red background color.

The method is as follows: 1. First, enter two sets of data that need to be compared in Excel**, and there are duplicate data in the two groups of data that need to be selected.

2. Then enter the function formula in cell C1: =if(countif(a:a,b1),"Repeat","This means that the data from B1 is used to find out if there are duplicates in column A.

3. Click Enter to see that the B1 cell of the comparison has duplicate data in column A, so the word "repeat" is displayed in the C1 cell.

4. Finally, fill the formula in the cell with Xiangtan downward, you can see that the cells with duplicate data in column B will be marked with words, and these cells can be singled out.

If you want to filter out certain numbers that are equal to a certain number from a column of data, you can use "Solver" under the "Data" option.

Example: If there are 10 numbers in cell A1:A10, you need to find out which cells are added to the target value of 215 66 by following the steps:

Step 1: Enter sumProduct in cell B11 (A1:A10, B1:B10). Mess with your hands.

Step 2: In the "Solver" under the "Data" option, take b11 as the target cell, the target value is 215 66, the variable cell is b1:b10, and the constraint of adding the variable cell is:

b1: b10 is an integer; b1: b10 is binary (i.e. 0 or 1), solve;

Step 3: This is you, you can determine the outcome of the plan's solution, and if it does, keep the result.

1. Open Excel and enter some data.

2. In the total column, enter the function [=subtotal(9,f2:f23)], press enter, and you can calculate the sum of the budget amount.

3. You can see that the total amount of the budget has been automatically generated.

4. If you want to calculate the sum of the actual amount, enter the function [=subtotal(9,a3:g3)], press enter, and it will be automatically calculated.

5. You can see that the total value of the actual amount has been automatically generated.

1. First of all, open the ** as shown in the figure below to do an example. Use the left mouse button to click on the content area and let the computer confirm that you need to operate on this **.

<>3. Click the drop-down arrow in the "B" column, remove the arrow in front of "Select All", and select "B"."c", and then you can see that Min San left only the data of b and c in **.

4. At the same time, the drop-down arrow has also become funnel-shaped, prompting the user to choose to use hail here.

5. In the filter, if there are too many data groupings and you can't find the data you want to select, you need to customize the search, as shown in the figure, enter "c" in the blank space under the customization, and all the data containing c will be automatically listed below. In this way, the screening of the data is complete.