回复 ntyyz 的帖子
I4=SUM(IF(COUNTIF($P$4:$P$14,考勤表!$D$4:$AH$4),IF((考勤表!$D5:$AH5="早")+(考勤表!$D5:$AH5="中")+(考勤表!$D5:$AH5="晚"),1,)))
J4=SUM(IF(COUNTIF($P$4:$P$14,考勤表!$D$4:$AH$4),IF((考勤表!$D5:$AH5="☆"),1,)))
K4=(E4+F4-SUM(IF(COUNTIF($P$4:$P$14,考勤表!$D$4:$AH$4),IF((考勤表!$D5:$AH5="早")+(考勤表!$D5:$AH5="晚"),1,))))*10
均为数组公式。