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

[µo°Ý] ¤@­Ó¦³±ø¥ó¦X·J­pºâ¥[Áo¨ç¼Æ

=SUM(COUNTIF(INDIRECT({"1¤ë","2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë","12¤ë"}&"!G"&ROW(A4)&":AK"&ROW(A4)),Sheet15!$X$3))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂhsieh¤j¤j,
µ{¦¡¤w¸Õ¥Î, ®ÄªG³»¦n,
hsieh¤j¤j, ¦pªG³o¨ç¼Æ¥Îvba½s¼g¬O§_¥i¥H, ¦]¬Û«H®ÄªG·|§ó¦n, ¦P®É¥ç·Q»{ÃѦhÂIvbaµ{¦¡,
ÁÂÁÂ, ¯¬§Ö¼Ö, °·±d..

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2010-7-26 22:11): ¸ÑÄÀ±o«Ü¦n

¥»©«³Ì«á¥Ñ luhpro ©ó 2010-7-26 21:50 ½s¿è
°J¤ßÁÂÁ¤j¤j«ü¾É,¤p©f¯uªº·MÄø,«ö¤j¤jªº«ü¥Ü,¦ýÁÙ¬O¤£¦¨¥\,§Ú§â¤½¦¡¶K©ó¤u§@ªí15,x4,Àµ½Ð¤j¤j¬Ý¬Ý¤p©f¦ó³B ...
317 µoªí©ó 2010-7-25 18:30


Excelªº¤½¦¡­n§â´¤¤@­Ó­ì«h,¨º´N¬O " ¤@©w­n¦¨¹ï,
³o¼Ë Excel ¤~¯àª¾¹D§Aªº¤½¦¡¤¤­þ¨Ç¬O¤å¦r,
¤S­þ¨Ç¬O¨ç¼Æ.

±q¤W­z¤º®e¨Ó¬Ý§Aªº¤½¦¡¨Ã¨S¦³¦¨¹ï,
§Ú­Ì¦b­åªR¤½¦¡ªº°ÝÃD®É¥i¥H¸ÕµÛ©î¸Ñ¤½¦¡,¦p :
=SUM(COUNTIF(INDIRECT({"1¤ë","2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë","12¤ë"}&"!G"&row()&":AK"&row()&"),Sheet15!$X$3))
¥i¥H©î¸Ñ¬° :
=SUM(
  COUNTIF(
    INDIRECT(
      {"1¤ë"
        ,"2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë"      <--- ³oÃ䥻À³¤]©î¸Ñ,¤£¹L©î¥X¨Ó¤å³¹·|ÅܤӪø,©Ò¥H¬Ù²¤.
        ,"12¤ë"}
        &     "!G"     &     row()    &    ":AK"   &    row()    &"
     )
   ,Sheet15!$X$3
   )
)
¬Ý¥X¨Ó¤F¶Ü? ¦h¤F & »P "
¥u­n§â¨º¨â­Ó¦r§R±¼´N¥i¥H¤F.
(«x? ¨S¬Ý¨ìÁÙ¦³²Ä¤G­¶, ¤]¨S¦³§R¤åªº¿ï¶µ? ¦pªGª©¥Dı±o³o½gÀ³¸Ó§Rªº¸Ü,´N½Ð§R¤F³á.)

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD