EXCL1909_201935008_유상민_.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)
[학생] : 5 =COUNTIF($B$4:$B$33,Q10) 4 =COUNTIF($B$4:$B$33,R10) 0 =COUNTIF($B$4:$B$33,S10) 2 =COUNTIF($B$4:$B$33,T10) 0 =COUNTIF($B$4:$B$33,U10) 3 =COUNTIF($B$4:$B$33,V10) 0 =COUNTIF($B$4:$B$33,W10) 5 =COUNTIF($B$4:$B$33,X10) 0 =COUNTIF($B$4:$B$33,Y10)