Record-s0340**.sxc
とする.
図1 成績集計表の完成図
=COUNTIF(B2:I2;"A")*5+COUNTIF(B2:I2;"B")*4+COUNTIF(B2:I2;"C")*3
=J2*100/40
=IF(K2>=80;"A";IF(K2>=70;"B";IF(K2>=60;"C";"D")))
=AVERAGE(J2:J17)
=STDEV(J2:J17)
=AVERAGE(K2:K17)
=STDEV(K2:K17)
=COUNTIF(L2:L17;"A")
Record-s0340**.sxc
とする.
図1 成績集計表の完成図
=COUNTIF(B2:I2;"A")*5+COUNTIF(B2:I2;"B")*4+COUNTIF(B2:I2;"C")*3
=J2*100/40
=IF(K2>=80;"A";IF(K2>=70;"B";IF(K2>=60;"C";"D")))
=AVERAGE(J2:J17)
=STDEV(J2:J17)
=AVERAGE(K2:K17)
=STDEV(K2:K17)
=COUNTIF(L2:L17;"A")
Back |