ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¦p¦ó±N¬Y°Ï¶ô¼Æ­È¤ÀÃþ(4¥H¤U¬°0¡A5¥H¤W¬°1)¨Ã¶i¦ÓÂà´«¦¨¥i­pºâªº¥[Á`

½Ð°Ý¦p¦ó±N¬Y°Ï¶ô¼Æ­È¤ÀÃþ(4¥H¤U¬°0¡A5¥H¤W¬°1)¨Ã¶i¦ÓÂà´«¦¨¥i­pºâªº¥[Á`

½Ð°Ý¦U¦ì¤j¤j¦p¦ó±N¬Y°Ï¶ô¼Æ­È¤ÀÃþ(4¥H¤U¬°0¡A5¥H¤W¬°1)¨Ã¶i¦ÓÂà´«¦¨¥i­pºâªº¥[Á`
¦pÀɮשҥÜA2~A9~AE2~AE29°Ï¶ô¤¤¦p¦ó¦Û°Ê¸õ¹L¨S¦³¶ñ¼Æ¦rªº¦a¤è§@¥­§¡
¥t¥~´N¬O¤ÀÃþ°µ¥[Á`¨Ó­pºâ¦Ê¤À¤ñ

¼Æ­È¤ÀÃþ+­pºâ¦Ê¤À¤ñ.rar (11.46 KB)

¤£§¹¥þÁA¸Ñ»Ý¨D¡A¸Ñµª¤£¹ï¡A¦A§iª¾¡C

¦]¤£§¹¥þÁA¸Ñ»Ý¨D¡A¥u¯à°µ¥X­Ó¤j·§¡C
AH7=SUM(AG2:AG7)/(COUNTA(A7:AE7)*COUNT(AG2:AG7))
A30=SUMPRODUCT((A$2:A$29>=5)*(A$2:A$29>=5))

¼Æ­È¤ÀÃþ+­pºâ¦Ê¤À¤ñ.zip (9.17 KB)

TOP

=(SUM(A2:AE29)-SUM(A2:A9,AE2:AE29))/(COUNT(A2:AE29)-COUNT(A2:A9)-COUNT(AE2:AE29))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

±N¬Y°Ï¶ô¼Æ­È¤ÀÃþ(4¥H¤U¬°0¡A5¥H¤W¬°1)¨Ã¶i¦ÓÂà´«¦¨¥i­pºâªº¥[Á`

=COUNTIF(A2:AE29,">=5")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

·PÁ¤j¤j­Ìªº¸Ñ´b
3Q~~~~

TOP

4¥H¤U¬°0¡A5¥H¤W¬°1

=COUNTIF(A2:AE29,">4")

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD