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

¬y¤ô±b¬d¸ß¤Î²Î­p

¬y¤ô±b¬d¸ß¤Î²Î­p

½Ð±Ð¦U¦ì¤j¤j
­n¦p¦ó±N¬y¤ô±b²£¥Í¬d¸ß³øªí
ªþ¤Wªþ¥ó ª÷ÃB¬d¸ß.rar (2.08 KB)

D2=SUMPRODUCT((B2=¬y¤ô±b!$B$2:$B$10)*(¬y¤ô±b!$D$2:$D$10=C2)*¬y¤ô±b!$E$2:$E$10)

TOP

¥t¤@ºØ«äºû

¥ý§â ¬y¤ô±b¤u§@ªí B1 ¦WºÙ§ï¬°²Î¤@ ¥s®×¸¹ §a

D2 ¤½¦¡¥i¥H³o¼Ë

=DSUM(¬y¤ô±b!$B$1:$E$1000,4,$B$1:$C2)-SUM(D$1:D1)

TOP

©êºp
¥i¯à¨S»¡²M·¡
À³¸Ó»¡B¤ÎCÄ椺¬OªÅ¥Õ­n²£¥Í¦³¦WºÙªº³øªí®æ¦¡¤Î¥[Á`
¦]¤p§Ìªº¬y¤ô±b(µ§¼Æ¤ñ¸û¤j)©Ò¥H¬O¥Î¸`¿ýªº¤è¦¡¤U¸üªºªí®æ
¦]¤£¤Ó·Q¥Î¤â°Êªº¤è¦¡²£¥Í®×¸¹¤Î¦WºÙ
¬O§_¥i¥H¥Î¤½¦¡ªº¤è¦¡ºÙ¥Í®×

TOP

¦^´_ 5# cchent


    ¨Ï¥Î¼Ï¯Ã¤ÀªR

ª÷ÃB¬d¸ß.rar (4.4 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


¤p§Ì¬O§Æ±æ±N¤@ªÅ¥Õ³øªíª½±µ¥Î¤½¦¡²£¥Í

ª÷ÃB¬d¸ß­×§ï.rar (2.93 KB)

TOP

¦^´_ 8# cchent


    ·íµM­n¥Î¤½¦¡±o¨ìµ²ªG¬O°µ±o¨ì
¦ý¬O¡A´N¦p§A©Ò»¡¡A¸ê®Æ¶q¤j¡A§Aªº¹q¸£®£©È·|¦Y¤£®ø
§A§ä¤@¤U¨ú±o¤£­«½Æ²M³æªº°µªk¡A´N¯à§â®×¸¹¡B¦WºÙ§ä¥X¨Ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

copy¬y¤ô±bBÄæ¨ì·s¤u§@ªíBÄæ
²¾°£­«½Æ
¥i±o°ß¤@ªº®×¸¹
¦p¤@©w­n¥Î¤½¦¡
b2=INDEX(¬y¤ô±b!B:B,MIN(IF(COUNTIF($B$1:B1,¬y¤ô±b!$B$2:$B$15),20,ROW($2:$15))))&""
°}¦C¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD