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

Excel 2000 ¥­§¡­È¦p¦ó¤£­pºâ¹sªºÀx¦s®æ

Excel 2000 ¥­§¡­È¦p¦ó¤£­pºâ¹sªºÀx¦s®æ

Excel 2000 ¥­§¡­È¦p¦ó¤£­pºâ¹sªºÀx¦s®æ??

ÁÂÁÂ!!

¦^´_ 1# panpan0930

°²³]­n­pa1 ¨ì a100 ¥B¼Æ­È³£¬°¥¿¼Æ

    =SUM(A1:A100)/COUNTIF(A1:A100,">0")

TOP

¦pªG¨S¦³ªÅ®æ
=SUM(A1:A100)/COUNTIF(A1:A100,"<>0")

¦³ªÅ®æ
=SUM(A1:A100)/(COUNT(A1:A100)-COUNTIF(A1:A100,0))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 1# panpan0930


=AVERAGE(A1:A100) ¤£¦æ¶Ü?
½Ð§â 0 ªºÀx¦s®æ²M°£¦¨¬°ªÅ´Ó
¦pÀx¦s®æ¤º§t¤½¦¡,«h±NÅã¥Ü 0 §ï¦¨""
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD