签到与签退分别统计，加一条件判断，用countifs( ) 函数实现：
签到 S2=COUNTIFS($C1:$R1,"签到",$C2:$R2,"漏刷") ，
签退 T2=COUNTIFS($C1:$R1,"签退",$C2:$R2,"漏刷")
请点击输入图片描述
