How to filter data with excel formula

How to filter data with excel formula

First use Excel 2010 to open the table that requires data. This table has two sub-forms. Form, click "Statistics" (as shown below)

Then enter the formula "=sum" after the first group and select the function "SUMPRODUCT" (as shown below)

Then enter "()*()" in English after SUMPRODUCT (as shown below)

Then move the cursor Go to the first bracket and click "Score" (as shown below)

Then select the column "Column A" where the group number is located (as shown below)

Then return to the statistical input "=a2", a2 is the position of group 1 in the statistics (as shown below)

Then Move the cursor to the second bracket and click "Score" (as shown below)

Select the column "Column B" where the scores are located (as shown below)

Then return to statistics and enter "

Then press the Enter key to output the first group Number of failed passes (as shown below)

For other groups, you only need to select the first group, and then pull down to output the failed scores, and then successfully use the formula to conditionally filter The required data (as shown below)

The above is the detailed content of How to filter data with excel formula. For more information, please follow other related articles on the PHP Chinese website!