EXCL1911_201924029_문수연.xlsm
[점수(100점 만점)] : 95
[상세점수] :
[과제(배점:100점)] : 95
[문제] : 과제, S12:S18, [틀림]학생수 계산이 틀렸습니다.
[정답] : 16 =COUNTIF($D$4:$D$103,R12) 18 =COUNTIF($D$4:$D$103,R13) 20 =COUNTIF($D$4:$D$103,R14) 15 =COUNTIF($D$4:$D$103,R15) 11 =COUNTIF($D$4:$D$103,R16) 9 =COUNTIF($D$4:$D$103,R17) 11 =COUNTIF($D$4:$D$103,R18)
[학생] : 16 =COUNTIF($D$4:$D$102,R12) 18 =COUNTIF($D$4:$D$102,R13) 20 =COUNTIF($D$4:$D$102,R14) 15 =COUNTIF($D$4:$D$102,R15) 11 =COUNTIF($D$4:$D$102,R16) 9 =COUNTIF($D$4:$D$102,R17) 10 =COUNTIF($D$4:$D$102,R18)