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

[µo°Ý] ¦p¦ó§ä¥X¥X²{¼Æ¦rÀx¦s®æªºÁ`¼Æ

[µo°Ý] ¦p¦ó§ä¥X¥X²{¼Æ¦rÀx¦s®æªºÁ`¼Æ

½Ð°Ý«ç¼Ë¥i§ä¥X«ü©w½d³ò(¨Ò¦p:A1¦ÜZZ100)
ªÅ®æ¤£§@²Î­p
¥u­pºâ¦³¼Æ­È(0-100)ªºÀx¦s®æ¼Æ¶q

¦^´_ 1# K_Wing


COUNTA¡G­pºâ«DªÅ¥ÕÀx¦s®æ¡C

COUNT¡G­pºâ¥]§t¼Æ¦rªºÀx¦s®æ¡C

COUNTBLANK¡G­pºâªÅ¥ÕÀx¦s®æ¡C

COUNTIF¡G­pºâ²Å¦X¯S©w·Ç«hªºÀx¦s®æ¡C
¤pªZ

TOP

¦^´_ 1# K_Wing


    =SUMPRODUCT((A1:ZZ100<>"")*(A1:ZZ100>=0)*(A1:ZZ100<=100))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# show5217
·PÁ«ü±Ð
¦³¤½¦¡·|§ó¦n

TOP

¦^´_ 3# Hsieh
¦X¥Î
«D±`·PÁÂ

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD