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

[µo°Ý] ½Ð°Ý¦p¦ó­pºâ°ÊºAªº¥­§¡­È

[µo°Ý] ½Ð°Ý¦p¦ó­pºâ°ÊºAªº¥­§¡­È

¦U¦ì¦n¡A§Ú¬O·s¤â½Ð¦h¦h¥]²[°ÝÃD¡G
¦³¼Æµ§¼Æ¦r¸ê®Æ¡A°²³]¦³10µ§¡A
¦ý10µ§¤¤¥u¦³ÀH¾÷´Xµ§·|¦³¸ê®Æ¡A¨º»ò§Ú­n¦p¦ó­pºâ¨Cµ§ªº¥­§¡­È©O¡H
¤ñ¦p»¡²Ä¤@¦¸¥u¦³1¡B3¡B5¡B7¡B9µ§¦³¸ê®Æ¡A­n±o¨ìªºµ²ªG´N¬O³o¤­µ§¥[Á`°_¨Ó«á°£¥H¤­ªº¥­§¡­È¡C
¤U¤@¦¸¦pªG¬O¥u¦³2¡B3¡B5¡B6¡B7¡B8¡B9¦³¸ê®Æ¡A­n±o¨ìªºµ²ªG´N¬O³o¤»µ§¥[Á`°_¨Ó«á°£¥H¤»ªº¥­§¡­È¡C
¨C¦¸¦³´Xµ§¬O°ÊºAÀH¾÷ªº¡A½Ð°Ý³o­n¦p¦ó¼g~

ÁÂÁÂ

¥»©«³Ì«á¥Ñ register313 ©ó 2011-11-17 23:54 ½s¿è

=AVERAGE(A1:A10)
=AVERAGE(A:A)

Àx¦s®æ¬°ªÅ¥Õ©Î¤å¦r®É AVERAGE¤£¦C¤J¥­§¡

TOP

ÁÂÁÂregister313¤jªº¦^µª¡A¦ý§Úµo²{average·|³s¹s­È¤]¤@°_·í°µ¥­§¡­È¤À¥À¡A¦pªG»~¸Ñ¦A½Ð«ü±Ð¡IÁÂÁÂ~

TOP

=IF(ISERROR(AVERAGE(A1:A10)),"",AVERAGE(A1:A10))

TOP

¦^´_ 3# alhuang88888


    ¤º©w°£¤FªÅ¥Õ¤Î¤å¦r¤£­pºâ¥~,0­È¬O­n­pºâªº,¦pªG¤£­pºâ0¥i¥Î¤½¦¡§P§O
=AVERAGE(IF(A1:A10=0,"",A1:A10))     °}¦C¤½¦¡

TOP

=averageif(A1:A10,"<>0")     

¤£¹L¸Ì­±¤£¯à¦³¤å¦r

TOP

¨Ó­Ó°ò¥»ªk:

=sum(A1:A10)/(count(A1:A10)-countif(A1:A10,0))

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-11-18 21:08 ½s¿è

¦^´_ 3# alhuang88888

=SUM(A1:A10)/COUNTIF(A1:A10,">0")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

°ò¥»¤Wºâ¥­§¡¼Æ­È¥Îaverage³Ì¨Î
§Ú»{¬°0À³¸Ó­nºâ,
°£«D0¨Ó¦Û¤½¦¡¹Bºâ§ä¤£¨ì©ÎªÅ¥Õ®ÉÀ³¤©­ç°£
À³¸Ó¦b¹B¥Î¤½¦¡®É´N¦Ò¼{¶i¥h
¦p¨Ï¥Îvlookup()®É,Áö¦³§ä¨ì¦ý¸ÓÅã¥ÜÀx¦s®æ¬°0,""³£·|¬O0
¥i¥H¥Îisnumber¥[¥H§P§O
=IF(ISNUMBER(VLOOKUP(D1,A1:B9,2,0)),VLOOKUP(D1,A1:B9,2,0),"")

¬G«Øij¥H¤@¯ë¥Îªºaverage³B²z©Î
=SUM(A1:A10)/COUNT(A1:A10)

¦p­n±Æ°£0¥i°Ñ¦Ò
=SUM(A1:A10)/(COUNT(A1:A10)-COUNTIF(A1:A10,0))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD