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

[µo°Ý] ½Ð±Ð¦p¸óÄæ¦ì­pºâÀx¦s®æ¼Æ¥Ø

[µo°Ý] ½Ð±Ð¦p¸óÄæ¦ì­pºâÀx¦s®æ¼Æ¥Ø

½Ð±Ð¦p¸óÄæ¦ì­pºâ(COUNT)Àx¦s®æ¼Æ¥Ø
¨Ò¦p:A1,B1,C1,D1,E1,F1,G1,H1,I1,J1
     ­pºâA1,D1,G1Àx¦s®æ¼Æ¥Ø
          ©ÎB1,E1,H1

    THANK YOU!

¦^´_ 1# alvinbluetw


    ¤£ª¾¹D§A­nªº¬OºØ­p¦³¸ê®Æ©Î¬O³æ¯ÂªºÀx¦s®æ­pºâ
    ¦³¸ê®Æªº­pºâ =COUNTA(A1,D1,G1)
    ³æ¯ÂªºÀx¦s®æ­pºâ=COUNTBLANK(A1)+COUNTBLANK(D1)+COUNTBLANK(G1)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 1# alvinbluetw

«DªÅ®æ¼Æ+ªÅ®æ¼Æ=¥þ³¡Àx¦s®æ¼Æ¶q
   =COUNTA(A1:J1)+COUNTBLANK(A1:J1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Thank!¤G¦ì«e½ú
§Úªº·N«ä¬O,¦³n­Ó¶µ¥Ø¨C­Ó¶µ¥Ø¦³4Äæ¦ì
¨Ò¦p:A1:¬°¶µ¥ØA2,B2,C2,D2¬°¶µ¥Ø²Ó¶µ
       E1:¬°¶µ¥ØE2,F2,G2,H2¬°¶µ¥Ø²Ó¶µ
       I1:¬°¶µ¥ØI2,J2,K2,L2¬°¶µ¥Ø²Ó¶µ
       M1:¬°¶µ¥ØM2,N2,O2,P2¬°¶µ¥Ø²Ó¶µ
¨C¤@­Ó¶µ¥Øªº²Ä¤@²Ó¶µ­n­pºâÀx¦s®æ¦³¶ñ¼Æ¦r(A2,E2,I2,M2)
                ²Ä¤G²Ó¶µ­n­pºâÀx¦s®æ¦³¶ñ¼Æ¦r(B2,F2,J2,N2)¥H¦¹Ãþ°ï
¦pªG¤@­Ó¤@­Ó«ö,¨C4®æ«ö¤@­Ó,§Ú¦³256Äæ
¤£ª¾§Ú³o¼Ë¸ÑÄÀ,«e½ú¬O§_ÁA¸Ñ§Úªº·N«ä.
THANK

TOP

¦^´_ 4# alvinbluetw

¸ê®Æ¤§±Æ§Ç¥i§_¦p¹Ï

TOP

½Ð°Ñ¦Ò


javascript:;

COUNT.jpg (62.65 KB)

COUNT.jpg

TOP

¦^´_ 6# alvinbluetw

B10=COUNTA(B3,F3,J3,N3)

TOP

Tankyou!
§Ú¦³256Äæ.

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-9 17:44 ½s¿è

¦^´_ 8# alvinbluetw


B10=SUMPRODUCT(($B$2:$Q$2=B$9)*($B3:$Q3<>""))
¥uºâBÄæ~QÄæ
­nºâBÄæ~¬Y¬YÄæ ¦Û¦æ§ï¤@¤U
B10=SUMPRODUCT(($B$2:$IV$2=B$9)*(ISNUMBER($B3:$IV3)))
B10=SUMPRODUCT(($B$2:$IV$2=B$9)*(ISNUMBER($B$3:$IV$7))*($A$3:$A$7=$A10))

TOP

ok! Thank you!
´N¬O¥¦--> ISNUMBER..

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD