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

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡ÅýEXCELªí®æ¦Û°ÊÅã¥Üµ§¼Æ

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡ÅýEXCELªí®æ¦Û°ÊÅã¥Üµ§¼Æ

½Ð°Ý¦U¦ì¤j¤j ¦p¦ó¥Î¤½¦¡ÅýEXCELªí®æ¦Û°ÊÅã¥Üµ§¼Æ
    ·í¦bA11Äæ¦ì¿é¤J¸ê®Æ«hB12Äæ¦ì«h¦Û°Ê±a¥X¦@1µ§
    ·í¦bA12Äæ¦ì¿é¤J¸ê®Æ«hB13Äæ¦ì«h¦Û°Ê±a¥X¦@2µ§
    ©¹¤U¥H¦¹Ãþ±À
    ·í¦bA12Äæ¦ì¸ê®Æ§R°£«hB13Äæ¦ì«h¦Û°Ê¸õ¦^B12 ±a¥X¦@1µ§
   
                ÁÂÁÂ

¥»©«³Ì«á¥Ñ mark761222 ©ó 2015-11-5 13:52 ½s¿è

COUNT(A11:A25) ­pºâ¥X³o½d³ò¦³¼Æ­Èªº¼Æ¶q

="¦@"&COUNT(A11:A25)&"µ§"

¦@´Xµ§¥i¯à­n©T©w¤@¤UÄæ¦ì¦b¿Ñ­Ó¦a¤è
¤£µM´N­n¼gVB¥h¬d¸ß³Ì«á¤@µ§¸ê®Æ¦Û°Ê¶ñ¤W¤F

TOP

¦b¸É¤@¤U¸ê®Æ
¦pªG§A¤£«Øijªí³æ¨C­Ó³£¼g¤½¦¡ªº¸Ü¡ABÄæ¶ñ¤U­±¸ê®Æ
=IF(B11="","","¦@"&COUNT(A11:A25)&"µ§")    ¼g¦bB12
=IF(B12="","","¦@"&COUNT(A11:A25)&"µ§")    ¼g¦bB13  
=IF(B13="","","¦@"&COUNT(A11:A25)&"µ§")    ¼g¦bB14

TOP

·PÁÂmark761222ªº¸Ñµª

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD