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

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

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

½Ð¤j¤j­Ì¨ó§U¸Ñ¨M
=COUNTIF(Sheet2!G4:AK4,X3)§Ú§â¨ç¼Æ¼g©ó¤u§@ªí15,X4Àx¦s®æ¤º,¨ç¼Æ¬O§â¤u§@ªí2,G4:AK4,²Å¦X±ø¥ó¥[Áo¥X²{¦¸¼Æ, ¦Ó°Ñ·Ó¦ì¸m¬O¤u§@ªí15,X3,Åã¥Ü©ó¤u§@ªí15,X4.Àx¦s®æ¤º.
¨ç¼Æ¥i¥H¨Ï¥Î,¦ý°ÝÃD¬O¦p¦ó§âSheet2:Sheet13¦@12±i¤u§@ªí¤ºg4:ak³£§@¦X·J¥[Áo, Åã¥Ü©ó¤u§@ªí15,X4.Àx¦s®æ¤º.
ÁÂÁÂ!!

  1. =SUM(COUNTIF(INDIRECT("Sheet"&{2,3,4,5,6,7,8,9,10,11,12,13}&"!G4:AK4"),Sheet15!X3))
½Æ»s¥N½X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

ÁÂÁ¤j¤j, ¤w¸Õ¥Î¹L, °J¤ßÁÂÁÂ, ¦ý¤p©f¦³­Ó°ÝÃD, °²­Y¤p©f§âsheet2:sheet13¦@12±i¤u§@ªí­«·s©R¦W,
sheet2©R¦W¬°2¤ë,sheet3©R¦W¬°3¤ë,¦p¦¹Ãþ±À,ª½¦Üsheet13©R¦W¬°12¤ë,¤î,
³o¼Ësheet2:sheet13¤u§@ªíªº¼ÐÅÒ¦WºÙ«K¬O1¤ë,2¤ë,3¤ë,4¤ë,5¤ë,6¤ë,7¤ë,8¤ë,9¤ë,10¤ë,11¤ë,12¤ë..
¦b³o±¡ªp¤U, ¨ç¼Æ¦p¦ó­×§ï,
ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ kimbal ©ó 2010-7-25 09:43 ½s¿è

¦^´_ 3# 317
  1. =SUM(COUNTIF(INDIRECT({"1¤ë","2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë","12¤ë"}&"!G4:AK4"),Sheet15!X3))
½Æ»s¥N½X
¶K¨ì¤â³n
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¤j¤j,¦­±á
ÁÂÁ¦^À³,¨ç¼Æ¶K¦b¤u§@ªí15, §Ú¦bSHEET15,X3¶ñ¤J50,
±µµÛ¦bSHEET2:SHEET13¤u§@ªíG4:AK4¦ì¸m¤W¿é¤J50,
¶Ç¦^#REF!,¤£ª¾¬O§_§Ú¦bµ{§Ç¤W¥X¿ù, ½Ð¤j¤j¨ó§U¸Ñ¨M, ÁÂÁÂ,
¯¬§Ö¼Ö..

TOP

¥ý¦æÁÂÁ¤j¤j, ¤¤¤È¦^®a¦A«×¸ÕÅç, ¤@¸Õ«K¦¨¥\, ¬O§_¤µ¦­ÁÙ¥¼ºÎ¿ô, ¸ÕÅç¦h¦¸³£¤£¦æ,¤¤¤È¤H¤w¹ý©³²M¿ô, ­ì¨Ó°ÝÃD¦b©ó¦Û¤v,
°J¤ß·PÁ¤j¤j, ¯¬¨­Åé°·±d..317

TOP

¤j¤j«e½ú, ¦w¦n,
·È¤F¤@­Ó°ÝÃDµo°Ý, ½Ð¤£­n¨£©Ç,¤½¦¡¤¤¥]§t°}¦C, °²­Y§Ú·Q§â¨ç¼Æ©¹¤U½Æ»s, ¸Ó¦p¦ó­×§ï, ¦]§Ú¸Õ¹L©¹¤U½Æ»s, «ö·Ó­pºâÀ³¬O½Æ»s¦ì¸m¤§¦Cg4:ak4¤~¬O, ¦ý§Ú©¹¤U½Æ»s¦Ü¦h¦C, ­pºâµ²ªG·Ç«hÁÙ¬Og4:ak4, ¨ì©³¦p¦ó­×§ï¤~¯à°µ¨ì©¹¤U½Æ»s, ÁÂÁÂ!!

TOP

INDIRECT¤U¥Îªº¬O¤å¦r,¤U©Ô¤]¬O¤@¼Ëªº,
¦pªG·Q¤½¦¡¸ò¦æ¼ÆÂàÅÜ,¥i¥H¦h¥[row()¨Ó¥Î

°²³]¤½¦¡¦ì¸m¦bsheet15 ªº²Ä4 row:
¨º²Ä¤@®æªº¤½¦¡,§âG4:AK4´«¦¨
G"&row()&":AK"&row()&
¦pªG¤½©Î¦ì¸m¦bsheet15ªº²Ä5 row:
¨º²Ä¤@®æªº¤½¦¡,§âG4:AK4´«¦¨
G"&(row()-1)&":AK"&(row()-1)&
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

°J¤ßÁÂÁ¤j¤j«ü¾É,¤p©f¯uªº·MÄø,«ö¤j¤jªº«ü¥Ü,¦ýÁÙ¬O¤£¦¨¥\,§Ú§â¤½¦¡¶K©ó¤u§@ªí15,x4,Àµ½Ð¤j¤j¬Ý¬Ý¤p©f¦ó³B¥X¿ù
=SUM(COUNTIF(INDIRECT({"1¤ë","2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë","12¤ë"}&"!G"&row()&":AK"&row()&"),Sheet15!$X$3))
¯uªº·Ð³Ò¤j¤j, ÁÂÁÂ!!, ¯¬§Ö¼Ö

TOP

³o½g¤å³¹, ©¹¤U©Ô½Æ»s, ¥[Áo·Ç«hg4:ak4,¸òÀHÅܧó,ÁÙ¥¼¦³¦^À³,¦ÑÁó­nÀɮפU¤ë¨Ï¥Î,
¬Ý¨Ó¦b¥¼¦³¸Ñ¨M¤èªk, ¤p©f¥ý¥Î¥j¦Ñ¤èªk, «K¬O§â¨ç¼Æ©¹¤U©Ô½Æ»s¦Ó1¤d¦h¦C¸ê®Æ,µM«á¦b¤½¦¡¤¤³v¦CÅܧóG4:AK4,Ä´¦p§Ú²{®É¬O¦b²Ä36¦C, §Ú«K§âG4:AK4,­×§ïG36:AK36,³v¦C³v¦CÅܧó,³o¤èªk¤]¥i¥H, ¦ý®É¶¡»Ý¼o®É.
=SUM(COUNTIF(INDIRECT({"1¤ë","2¤ë","3¤ë","4¤ë","5¤ë","6¤ë","7¤ë","8¤ë","9¤ë","10¤ë","11¤ë","12¤ë"}&"!G4:AK4"),Sheet15!$X$3))
¤p©f¦b¦¹¦A¦¸°J¤ßÁÂÁÂkimbal¤j¤j«ü¾É¤W­z¨ç¼Æµ¹¤©¤p©f,ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD