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

[µo°Ý] ¬D¿ï½d³ò-¨ç¼Æ°ÝÃD

[µo°Ý] ¬D¿ï½d³ò-¨ç¼Æ°ÝÃD

¥»©«³Ì«á¥Ñ SunnyKen ©ó 2010-10-14 07:46 ½s¿è

¦U¦ì®v³Å«e½ú­Ì

§Ú¥Ø«e¦bA1~A10¦³¶ñ¼g[0,2,0,4,6,8,7,0,2,4]¼Æ­È¡A
­n¦p¦ó¬D¿ï½d³òA1~A10¸ÌÀYªº[0]¼Æ¦r©O¡A
´Nµ¥©ó¬O»¡¬D¥Xªº¼Æ¦r¦bA11(Åã¥Ü¦³"3"­Ó¼Æ¶qªº[0]
[0,2,0,4,6,8,7,0,2,4] [3]
    ¡ô¬O¦bA1~A10¡ô       ¡ô¬O¦bA11¸ÌÀYªº0¼Æ¶q

»Ý­n¥[¤J­þºØ¨ç¼Æ¤~¥i¥H°µ¬D¿ï¼Æ¶q??
¥H¤W´N¬O§Úªº°ÝÃD¡A§Æ±æ½Ð¨D¦U¦ì¥i¥HÀ°§Ú¸Ñµª¡A·PÁÂ!!

¦^´_ 1# SunnyKen
=COUNTIF(A1:A10,0)

TOP

¥»©«³Ì«á¥Ñ SunnyKen ©ó 2010-10-14 07:45 ½s¿è

¦^´_ 2# GBKEE

¦^´_ 3# ¦Ñ®L

ÁÂÁ®v³Åªº±Ð¾É¡A±z­Ì¨â­Óªº±Ð¾Ç§Ú³£¦³¹ê»Ú¾Þ§@¹L¤@¦¸¡A
¦b³o°Q½×°Ï¸Ì±q¤¤·P¨ü¨ì³Q¨ü·ÓÅU¤@¯ë¡AÅý¾ÇEXCEL¤]¤£·|°g¥¢»P®`©ÈªºÀô¹Ò¤¤¾Ç²ß....


­Y¬O´«¦¨¤£­n¿ï¾Ü0ªºÁ`©M¡A§ï´«A1~A10¤§¤¤ªº(1~9)¼Æ¦rªº­Ó¼Æ¨Ò¦p
µ²ªG·|Åܦ¨
[0,2,0,4,6,8,7,0,2,4] [7]
    ¡ô¬O¦bA1~A10¡ô       ¡ô¬O¦bA11¸ÌÀY1~9ªº¼Æ¶q
»Ý­n¥[¤J­þºØ¨ç¼Æ¤~¥i¥H°µ¬D¿ï¼Æ¶q??
¦A½Ð¨D¦U¦ì®v³Åªº¨ó§U...

TOP

¥»©«³Ì«á¥Ñ SunnyKen ©ó 2010-10-14 17:47 ½s¿è

¦^´_ 5# ¦Ñ®L

¦Ñ®L¤j¤j¡A¦]¿z¿ïªº³¡¤À­Y¤£¦Ò¼{¨Ï¥Î¡Aª½±µ¥H¤½¦¡§@·~

©êºp¦Ñ®L~§Ú¤º®e¤W¦³»~¡A¸ê®Æªí¤W¬Ý¨ìªº¬O[A1~J1][K1]¡×[0,2,0,4,6,8,7,0,2,4][7]

¦p"GBKEE"©Ò´£¥Xªº¥H=COUNTIF(A1:A10,0)¡A¬O¥i¥H§â[0]¬D¿ï¥X¨Ó

­Y´«­Ó¤è¦Vªº¸Ü¡A³o¦¸¨Ã«D¬D¥X[0]¦Ó¬O±N[1~9]ªº¼Æ¦r¤¤¬D¿ï

¦Ó§Ú­è­è¬O¥Î
          [A1~J1]           [K1]   [J1]   [L1]
[0,2,0,4,6,8,7,0,2,4]  [10]   [3]     [7]

¦b[K1]°µ=COUNTA(A1:J1)         Åã¥Ü10
¦b[J1]°µ=COUNTIF(A1:J1,0)      Åã¥Ü3
¦b[L1]°µ=K1-J1                         Åã¥Ü7

³o¼Ëªº¤èªk¬O§_ÁÙ¦³Â²©ö¨ç¼Æ¥i¥H¨Ï¥Î©O

TOP

¦^´_ 3# ¦Ñ®L


§Ú¤]±q«e½úªº¸Ñ»¡¸Ì¾Ç¨ì¤F­ì¨Ósubtotal¸Ì«e­±ªº¼Æ¦r¤£¦P¡A¥Nªí¤£¦P¥\¯à¡A¥i§_½Ð±Ð«e½ú¨ì­þ¸Ì¥i¥H§ä¨ì¸Ñ»¡¤£¦P¼Æ¦r©Ò¥Nªíªº²[¸q©O¡H¨Ò¦p¡G±z¦b©«¤l¤¤´£¨ìªº¢²©M¢¸¦U¥Nªí¦ó²[¸q¡A¨º»ò¨ä¥L¼Æ¦r¤S¬O¥Nªí¤°»ò²[¸q©O¡HÁٽбz¤£§[½ç±Ð¡AÁÂÁ¡I

TOP

¦^´_ 7# onegirl0204


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# ¦Ñ®L

«D±`·PÁ¦ѮL¤ÎHsieh¨â¦ì«e½úªº«üÂI¡I
­è­èÀH¤â¦bÀx¦s®æ¸Ì¥´¤F¢·Äæ¼Æ¦r¡A¸ÕµÛ¥Îsubtotal´ú¸Õ¡Aµ²ªG¼Æ¦r¢±¤Î¢²¡]count&counta¡^³£¬O¥X²{¢·¡A¤£ª¾¤GªÌ¦³¦ó®t²§¡HÁ٬߫e½ú¦A«üÂI¡AÁÂÁ¡I

TOP

­Y§A¥´ªº¤À§O¦³¼Æ¦r»P¤å¦r¡A§A´N¥i¬Ý¥X¤£¦P³B¤F¡C
«ØijÁÙ¬O¦hŪ»¡©ú§a¡I

TOP

¦^´_ 10# onegirl0204


    ¬°¤F²Ö¿nÂI¼Æ¡A©Ò¥H°Ý³oºØ°ÝÃD¡A  :-)
    ¬°¤F²Ö¿nÂI¼Æ¡A©Ò¥HÂà¶K³o¨Ç¦r¡C  :-)

COUNT
­pºâ§t¦³¼Æ¦rªºÀx¦s®æ¼Æ¶q¡A¥H¤Î¤Þ¼Æ²M³æ¤¤ªº¼Æ¦r¡C¨Ï¥Î COUNT ¥i¥H¦b¤@­Ó¼Æ¦r°}¦C©Î½d³ò¤¤¨ú±o¤@­Ó¼Æ¦rÄæ¦ì¤ºªº¶µ¥Ø¼Æ¶q¡C
»yªk
COUNT(value1,value2,...)
Value1, value2, ...     ¬O 1 ¨ì 30 ­Ó¤Þ¼Æ¡A¸Ì­±¥i¯à§t¦³©Î°Ñ·Ó¨ì¤£¦PÃþ«¬ªº¸ê®Æ¡A¦ý¥u­pºâ¼Æ¦r³¡¥÷¡C
µù¸Ñ
•¥i¥H¦C¤J­pºâªº¤Þ¼Æ¦³¼Æ¦r¡B¤é´Á©Î¥Nªí¼Æ¦rªº¤å¦r¡C¤£¦C¤J­pºâªº¤Þ¼Æ¦³¿ù»~­È¡A¥H¤Î¤£¯àÂà´«¦¨¼Æ¦rªº¤å¦r¡C
¦pªG¤Þ¼Æ¬O¤@­Ó°}¦C©Î°Ñ·Ó¡A«h¥u­pºâ³o­Ó°}¦C©Î°Ñ·Ó¤¤ªº¼Æ¦r¡C³o­Ó°}¦C©Î°Ñ·Ó¤¤ªºªÅ¥ÕÀx¦s®æ¡BÅÞ¿è­È¡B¤å¦r©Î¿ù»~­Èµ¥¡A³£¤£¤©­pºâ¡C¦pªG±z»Ý­n­pºâÅÞ¿è­È¡B¤å¦r©Î¿ù»~­È¡A±z¥i¥H¨Ï¥Î COUNTA ¨ç¼Æ¡C
©Ò¥H¡A¦pªG¿é¤J8­Ó¼Æ¦r¡Aµ²ªG·íµM·|¤@¼Ë¡C¸ÕµÛ¬Y¨Ç³æ®æ¤¤¿é¤J¤å¦r¡A´N·|¤£¤@¼Ë¡C
joviwang

TOP

¦^´_ 12# joviwang


    ·PÁ½ç±Ð¡I¦Û¾Çexcel¦³®É¬Ý¨ì¤@ªø¦êªº¤å¦r¸Ñ»¡¤£¨£±o·|§¹¥þ©ú¥Õ¡A´N¦n¤ñ¬Ý¤å¨¥¤å¡]¤ñ³ë¦n¹³¦³ÂI¸Ø±i¡^¡AµM¦Ó¸g¤H«üÂI¥[¹ê¨Ò¸Ñ»¡«á´N¤ñ¸û©ú¥Õ¤F¡I

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD