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!