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

¦p¦ó­pºâ¥[Á`¥­§¡­È

·PÁ samenameboy , register313 ¤j¤j,¥i¬O¥Ø«eªí®æ±qb1 ¶ñ¨ì d4, n4®æªº¥[Á`¥­§¡¥L«oµ¹§Ú°£¥H12, (À³¸Ó¬O°£¥H3)³o¼Ëªº¥­§¡¬O¿ùªº,¤£ª¾¬°¦ó·|³o¼Ë? ½Ð¨â¦ì¤j¤jÀ°À°¦£,¥ýÁ¤F!

TOP

¦^´_ 1# petercom

³o©Û§Ú±`¥Î~°Ñ¦Ò¬Ý¬Ý!!
    =IF(ISERROR(AVERAGE(B1:B4)),"",AVERAGE(B1:B4))

TOP

¦^´_ 3# petercom

B6=IF(COUNTA(B2:B5)=0,0,AVERAGE(B2:B5))

TOP

·PÁÂregister313 §Ö³t¦^µª,¦p¦ó¦bB2,3,4,5 ¥¼¿é¤J¼Æ¦r¤§B6ªí®æ¤£¥X²{#DIV/!,¥ý¦A¦¸·PÁ±zªº¦^µª!

TOP

¦^´_ 1# petercom

B6=AVERAGE(B2:B5)

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD