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

[µo°Ý] ¸ê®Æ¤ÀÃþ¥[Á`

[µo°Ý] ¸ê®Æ¤ÀÃþ¥[Á`

¥»©«³Ì«á¥Ñ matsuguest ©ó 2011-6-14 21:50 ½s¿è

¦U¦ì ¤j®a¦n¡G

Ãö©ó¸ê®Æ¤ÀÃþ¥[Á`¦³­Ó°ÝÃD·Q½Ð±Ð

­nÅý¥x¥__¤j¾Ç¡B¥x¥__¬ì§Þ¤j¾Ç¡B¥x«n_¤j¾Ç¡B°ª¶¯_¤j¾Ç¤À§O§@¥[Á`

§Ú¸ÕµÛ¦bB2Àx¦s®æ¼g =SUMIF(B12:F12,LEFT(B12:F12,5)=B1,B13:F13)¤½¦¡¬O¿ùªº

½Ð°Ý¦U¦ì«e½ú¸Ó«ç»ò¥Î¨ç¼Æ±a¥X¨Ó©O?

¦pªþ¹Ï©Ò¥Ü



²Ä¤@¦¸¦b³Â»¶®a±Ú½×¾Âµo¨¥
¦³¥¢Â§¤§³BÁٽЦU¦ì¦h¨£½Ì

¾Ç®Õ¾P°â¸ê®Æ.zip (7.38 KB)

¾Ç®Õ¾P°â¸ê®Æ

½Ð°ÝB$1&"*"¤¤ªº&"*"ªº·N«ä¬O¤°»ò?
*¸¹¬O¸U¥Î¦r¤¸,¥Nªí¥ô¦ó¦r¤¸
&¬O³s±µ²Å¸¹
b1=¥x¥__¤j¾Ç
B1&*=¥x¥__¤j¾Ç?????????
­n¤ñ¹ïªº½d³ò¥u­n§t¥x¥__¤j¾Ç¤£ºÞ«á­±¥[Ô£ªF¦è³£ºâ²Å¦X.

TOP

·PÁÂHsieh ªº´£¿ô,,,ÀɮפwÀ£ÁY¤W¶Ç

ÁÂÁÂliu5201 ¤j¤jªº¸Ñµª
½Ð°ÝB$1&"*"¤¤ªº&"*"ªº·N«ä¬O¤°»ò?

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-6-13 10:26 ½s¿è

½Ð¸Õ¸ÕB2Àx¦s®æ¼g =SUMIF($B$12:$F$12,B$1&"*",$B13:$F13)
¬O§_¦³§ó²³æ¤§®æ¦¡½Ð¦U¦ì¤j¤j«ü¥¿

TOP

¦^´_ 1# matsuguest


    ½Ð±NÀÉ®×À£ÁY¤W¶Ç
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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