Lenovo Xiao Xin pad? Take Pro 1 1.5 computer, win 10 professional edition and Excel20 10 edition as examples. COUNTIF formula can be used to count the score of 90- 100. The idea is that the two COUNTIF formulas mean that the total number of people with 90 points or more minus 100 points is 90 points or more and kloc-0/00 points or less. The specific operation method is as follows:

1, open the required Excel file on the computer to enter.

2. After entering the Excel file, enter =COUNTIF(B2:B7, "& gt=90"). Represents the total number of people with 90 points or more.

3. Then continue to enter -COUNTIF(B2:B7, "> 100"). The two COUNTIF formulas mean that the total number of people with more than 90 points minus 100 points is more than 90 points and less than 100 points.

4. After the input is completed, press enter and see that the number of people with 90 points-100 points has been counted.