How to make a formula calculate only the filtered part in excel

How to make the formula only calculate the filtered part in Excel: First open a worksheet to be filtered, select the items to be filtered, and click the filter command; then filter out the condition part, select it, and click Auto Find And that's it.

How to make the formula only calculate the filtering part in excel:

#1. Open a file to be filtered worksheet.

#2. Select the items you want to filter and click the filter command.

#3. The filtering condition is class, and all students in Class 1 will be filtered out.

#4. Select the average scores of all the students in Class 1 and click Automatic Sum. Then we can calculate the total average scores of all the students in Class 1.

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to make a formula calculate only the filtered part in excel. For more information, please follow other related articles on the PHP Chinese website!