A1:姓名,B1:语文,C1:数学...,A2-A100,全部人员的名字,B2-B100,对应人员输入语文科目是参考或缺考,C2-C100,对应人员输入数学科目是参考或缺考...,在A101输入:参考人数,A102:缺考人数...,
B101输入:=COUNTIF(B2:B100,"参考")
B102输入:=COUNTIF(B2:B100,"缺考")
C101输入:=COUNTIF(C2:C100,"参考")
C102输入:=COUNTIF(C2:C100,"缺考")
...
温馨提示:答案为网友推荐,仅供参考