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

[µo°Ý] [µo°Ý]¸ê®ÆÅçÃÒ-²M³æ°ÝÃD

[µo°Ý] [µo°Ý]¸ê®ÆÅçÃÒ-²M³æ°ÝÃD

¤§«e°µªí®æªº®É­Ô³£·|«Ü±`¥Î¨ì²M³æ

©Ò¥H³£·|§â­n²M³æ¸Ì­±ªºªF¦è¥þ³¡³£¥´¦b¥t¥~¤@­Ó¬¡­¶Ã¯

«á¦b¥h°µ³]©w



´N¹³¬O§Ú³£·|§â­n°µ¦¨²M³æªº³£¥´¨ìindexªº¬¡­¶Ã¯

µM«á¦A±q­n°µ¤U©Ô¬O¿ï³æªº¦s®æ¸ÌÂI¸ê®ÆÅçÃÒ->²M³æ µM«á¥h°é¿ï





¥i¬O¤µ¤Ñ¦b°µ¨ä¥Lªí®æªº®É­Ô

§Ú¤]¬O¥ý§â­n°µ¦¨¿ï³æªºªF¦è³£¥´¨ìsheet3¸Ì

¥u¬O·í§Ú¦^¥hsheet1­n¥h¸ê®ÆÅçÃÒµM«á­n¿ï³æ®É

¨S¦³¿ìªk¿ï¨ú¥hsheet3

¨S¦³¿ìªk¿ï¨ú¥hsheet3
¬O¨S¿ìªk§r
¸Ñ¨Mªº¤è¦¡¬O©w¸q¦WºÙ
©Îindirect¨ç¼Æ

TOP

¦^´_ 2# oobird


¨º½Ð°Ý¤@¤U¤j¤j¸Ó«ç»ò¥h³]©w©O

TOP

«e­±«Ü¦h¬Û¦Pªº°ÝÃD¡A§ì¤@­Ó
http://forum.twbts.com/viewthrea ... ighlight=%B2M%B3%E6

TOP

¸ó¤u§@ªíÅçÃÒ, ¦poobirdª©¥D©ÒÁ¿, ¤p©f¥Îªº¬O¦WºÙ, ¥ý¦æ§â­nÅçÃÒªºÀx¦s®æµ¹¤©¦WºÙ, ¥i°Ñ¦Òoobirdª©¥D´£¨Ñªº¸ô®|. ­Y¤£©ú, ¦Aµo°Ý....

TOP

¦^´_ 4# oobird


·PÁª©¤j!!!¤F¸Ñ

TOP

¦^´_ 5# 317



¤£¦n·N«ä¥i¥H½Ð°Ý¤@¤U~(¤£¦n·N«ä¤@ª½³Â·Ðª©¤j;P )

¦pªG§Ú·Q­pºâAX6©MAX10¨â®æ³£¦óÃs¬w¡AµM«á­pºâAZ5©MAZ11¨â®æÄÁÂIªºÁ`¦X

EXCEL¸Ì¦³¼Ëªº¨ç¼Æ¥i¥H³]©w¶Ü???

1.JPG (23.3 KB)

1.JPG

TOP

=SUMPRODUCT((AX6:AX10="¦óÃs¬w")*(AZ5:AZ9))
­n­pºâªº¦a¤è,³Ì¦n¤£­n¥Î¦X¨Ö®æ

TOP

¦^´_ 8# ANGELA

®¦®¦!!¤F¸Ñ!!!

¦A½Ð°Ý¤@¤U(¤£¦n·N«ä....°ÝÃD¦³ÂI¦h)

¦pªG¬O¹J¨ì³oºØªº

¦³¿ìªk³]©w¤]¬O¥u³æºâ¦óÃs¬w¶Ü

TOP

=sumif(AX6:bb20,"¦óÃs¬w",az5)

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD