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

½Ð¤j®aÀ°¦£§ì¿ù...¨ºÃä³]¿ù¤F (§ìÀYing)

½Ð¤j®aÀ°¦£§ì¿ù...¨ºÃä³]¿ù¤F (§ìÀYing)

¥»©«³Ì«á¥Ñ yunyun ©ó 2013-1-7 09:50 ½s¿è

®w¦sªí-­±ªO.rar (20.06 KB) ¤j®a¦n!!!
¤p©f§Ú±qºô¸ô¤W§ì¤F¤@¥÷excelªí®æ¡A¦Û¦æ§ó§ï¦¨®w¦sªí¨Ó¨Ï¥Î¡A¦ý°ÝÃD¨Ó¤F.....

¦b"µn¿ý¶i¥X³fsheet" ¡A§Ú¿é¤J¶i³f¼Æ¶q¡A¦b®w¦sªí·|¹ïÀ³¦¹¶µ¥Ø¥[Á`¡A¦ý§Ú¿é¤J¥X³f¼Æ¶q¡A¤]·|¹ïÀ³¥[Á`¡A¦b¶i³f©M¥X³f¦P®É¿é¤J¼Æ¶q¡A¤Ï¦Ó·|¥ý¬Û´î«áªº¼Æ¦r¦bÂk¨ì"®w¦sªí"¡C

¦³ÂIÁ¿¨ì»yµL­Û¦¸¤F.....§Ú·Q­nªº¬O¡A§Ú¦b¥´¶i³f¼Æ¶q®É¡A¥i¦b®w¦sªí¥[¦¹¼Æ¶q¡C¦b¥´¥X³f¼Æ¶q®É¡A¥i¦b®w¦sªí¦©¦¹¼Æ¶q¡C¤w­«³]¹L«Ü¦h¦¸.....¦ýµL¸Ñ¡A½Ð¤j®aÀ°À°¦£¡C

¤½¥q¤p©f ·q¤W

Yun

¦^´_ 1# yunyun
©w¸q¦WºÙ:    ¶i³f=OFFSET(µn¿ý¶i¥X³f!$F$6,,,COUNTA(µn¿ý¶i¥X³f!$D$6:$D$65536),1)
©w¸q¦WºÙ:    ¥X³f=OFFSET(µn¿ý¶i¥X³f!$G$6,,,COUNTA(µn¿ý¶i¥X³f!$D$6:$D$65536),1)
®w¦s¼Æ¶q =SUMIF(¬ì¥Ø1,$B80,¶i³f)-SUMIF(¬ì¥Ø1,$B80,¥X³f)

TOP

ÁÂÁ«ü±Ð....ÁöµMÁÙ¬O¸Õ¤£¤Ó¥X¨Ó¡A¦b©w¸q¦WºÙ³¡¤ÀÁÙ¬OÅã¥Ü¿ù»~¡A¦ý§Ú¦b§V¤O¸Õ¬Ý¬Ý....

¥Ì·Å°Ú
Yun

TOP

¦^´_ 1# yunyun
³oÀ³¸Ó¬O´`Àô°Ñ·Ó°ÝÃD
¦]¬°§Aªº®w¦s¬O­n=¶i³f¶q+­ì®w¦s¶q
=SUMIF(¬ì¥Ø1,$B4,ª÷ÃB1)+C4
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    +C4 «á......  ¨º­ÓÀx¦s®æÅܪťդF..... :L
Yun

TOP

¦^´_ 5# yunyun

ª÷ÃB1½d³ò¤ºªº¤½¦¡¥ÎABS¦n¹³¤£¦X²z
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤w¸Ñ¨M°ÝÃD....°Õ°Õ°Õ  ·PÁ¤j®aªº´£ÂI  (Åxªá)  :P
Yun

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD