满七个优秀就是三级，良好优秀加起来满七个就是二级，良好优秀加起来不满七个就是一级的函数公式怎么写

Question

如题所述

Answer 1

假设，姓名在A列，科目1-科目十为B列：K列，定级为L列，则在L2输入：
=IF(COUNTIF(B2:K2,"优秀")>6,"三级",IF(COUNTIF(B2:K2,"优秀")+COUNTIF(B2:K2,"良好")>6,"二级",IF(COUNTIF(B2:K2,"优秀")+COUNTIF(B2:K2,"良好")>0,"一级","不达标")))
下拉填充公式即可。