EXCL1904_201979033_이소현_131843_assignsubmission_file_201979033 이소현.xlsm

[점수(100점 만점)] : 90

[상세점수] :
        [과제(배점:100점)] : 90

[문제] : 과제, O10:O18, [틀림]인원이 틀렸습니다.

[정답] : 	2	=COUNTIF($J$4:$J$33,N10)
	3	=COUNTIF($J$4:$J$33,N11)
	3	=COUNTIF($J$4:$J$33,N12)
	5	=COUNTIF($J$4:$J$33,N13)
	8	=COUNTIF($J$4:$J$33,N14)
	4	=COUNTIF($J$4:$J$33,N15)
	3	=COUNTIF($J$4:$J$33,N16)
	1	=COUNTIF($J$4:$J$33,N17)
	1	=COUNTIF($J$4:$J$33,N18)

[학생] : 	2	=COUNTIF(J4:J33,N10:N18)
	3	=COUNTIF(J5:J34,N11:N19)
	3	=COUNTIF(J6:J35,N12:N20)
	5	=COUNTIF(J7:J36,N13:N21)
	8	=COUNTIF(J8:J37,N14:N22)
	3	=COUNTIF(J9:J38,N15:N23)
	2	=COUNTIF(J10:J39,N16:N24)
	1	=COUNTIF(J11:J40,N17:N25)
	0	=COUNTIF(J12:J41,N18:N26)