2. Enter the students' grades. A set of data is simulated here. 1 * * Yes 1 1 person:

3, input conditions, mathematics is greater than 90, English is greater than 90, pay attention to the staggered columns represent two different conditions, greater than the symbol using English input method:

4, click on the data in the toolbar above:

5, click on the filter fat senior:

6. Select the data just entered in the list area:

7. Conditional area selection The conditional area you just entered is greater than 90:

8. As a result of advanced screening, 8 people scored above 90 in math or English.