Excellent rate: for example, if the score is above 80, then calculate the excellent number first: =countif(D2:L34, "& gt=80"). If the result is: A. Then use =count(D2:L34) to calculate the number of people in all grades. If the result is B; Finally, you can use = a/b to calculate the excellent rate, and similarly, the pass rate is the same. Specifically, you can change the formula.