Excel中参考人数和缺考人数用什么函数来统计,最好能分别举例.回答的好...答:A1:姓名,B1:语文,C1:数学...,A2-A100,全部人员的名字,B2-B100,对应人员输入语文科目是参考或缺考,C2-C100,对应人员输入数学科目是参考或缺考...,在A101输入:参考人数,A102:缺考人数...,B101输入:=COUNTIF(B2:B100,"参考")B102输入:=COUNTIF(B2:B100,"缺考")C101输入:=COUNTIF(C2:C100,"...
请问以下excel表格中,如何根据上课周次统计出上课周数?用什么函数?答:需要先判断有几个“-”,即有几段数据。原理就是取出“-”右侧、左侧的数据作差再+1,就是1段数据的周数。B3=IF(LEN(A3)-LEN(SUBSTITUTE(A3,"-",""))=1,RIGHT(A3,LEN(A3)-FIND("-",A3))-LEFT(A3,FIND("-",A3)-1)+1,MID(A3,FIND("-",A3)+1,FIND(",",A3)-FIND("-",...
Excel如何用函数统计人数,出现多次只算一人?答:=多项查询($C:$C,$B:$B,E$17,,2)'自定义公式-按ALT+F11-插入-模块-粘贴代码-将表格另存为启用宏的格式 Function 多项查询(a As Range, b As Range, c As String, Optional ByVal fgf As String = "|", Optional ByVal 模式 As String = 1)If a.Cells(3, 1) <> "" Then ...