EXCL1909_201979014_정인양_Junginyang.xlsm
[점수(100점 만점)] : 95
[상세점수] :
[과제3(배점:100점)] : 95
[문제] : 과제3, Q11:Y11, [틀림]인원 계산이 틀렸습니다
[정답] : 4 =COUNTIF($K$4:$K$33,Q10) 3 =COUNTIF($K$4:$K$33,R10) 3 =COUNTIF($K$4:$K$33,S10) 5 =COUNTIF($K$4:$K$33,T10) 6 =COUNTIF($K$4:$K$33,U10) 4 =COUNTIF($K$4:$K$33,V10) 3 =COUNTIF($K$4:$K$33,W10) 1 =COUNTIF($K$4:$K$33,X10) 1 =COUNTIF($K$4:$K$33,Y10)
[학생] : 4 =COUNTIF(K4:$K$33,Q10) 3 =COUNTIF($K4:L$33,R10) 3 =COUNTIF($K4:M$33,S10) 5 =COUNTIF($K4:N$33,T10) 6 =COUNTIF($K4:O$33,U10) 5 =COUNTIF($K4:P$33,V10) 3 =COUNTIF($K4:Q$33,W10) 2 =COUNTIF($K4:R$33,X10) 1 =COUNTIF($K4:S$33,Y10)