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

[µo°Ý] ±ø¥ó¥[Á`°ÝÃD

[µo°Ý] ±ø¥ó¥[Á`°ÝÃD

½Ð±Ð¦U¦ì¤j¤j~
­n±q¤@­ÓTable¤¤

¬d¸ß¥[Á`¬YºØ²£«~¤w¸g¹L¬Y¤@¯¸ªº¥[Á`
Count.jpg
¨Ò¦pAAAA0009«~¶µ¦b#1010¯¸«áªº¥[Á`=1434(¶À©³)
¤½¦¡­n¦p¦ó³]©w¡AÁÂÁ¡I
°ÝÃD20161014.rar (7.94 KB)
Adam

B2= =VLOOKUP($A2,WIP!$C:$D,2,)-SUM(OFFSET(WIP!$C$1,MATCH($A2,WIP!$C:$C,0)-1,2,,MATCH(LEFT(B$1,4),WIP!$1:$1,0)-4))

TOP

·PÁÂfengetianxia¥X¤â¬Û§U¡A©Ò¥H¬O§Q¥ÎOffset§ä¥X¥¼¹L¯¸ªº°Ï°ì¤§«á¥ÎÁ`¶q´î¥h¡A¯u¬O¨ü±Ð¤F¡A¤Ó·PÁ¤F~
Adam

TOP

«¢,¨ä¹ê¬O«e´X¤Ñ¤~¦Vª©¥DML089¾Ç²ßªº,¤j®a¤¬¬Û¾Ç²ß,¤¬¬Û¶i¨B

TOP

=SUMPRODUCT(OFFSET(WIP!$C$1,MATCH($A2,WIP!$C$2:$C$11,),MATCH(LEFT(B$1,4),WIP!$1:$1,)-2,,99))

TOP

¦^´_ 5# hcm19522

   ·PÁ hcm19522 ´£¨Ñ¥t¤@ºØª½±µ­pºâ¸ÓÄæ¦ì©¹«á¥[Á`ªº¤½¦¡¡A©Ò¥H­«ÂIÀ³¸ÓÁÙ¬O Offset ªº¹B¥Î
¬Ý¨ì¦U¦ì¤j¤j´£¥X¸Ñµªªº®É­ÔÁ`¬O«éµM¤j®©¡A¤£¹L¦Û¤v·Q¥b¤Ñ´N¬O¤£·|·Q¨ì¡A¤]³\³o´N¬O©Ò¿×ªº¼h¦¸¤£¦Pªº®t¶Z§a¡I
©Ò¥H³o¸Ì¯u¬O¤@­Ó´£ª@¼h¦¸ªº¦n¦a¤è§r¡A·PÁ¤j¤j¦U¦ìªº¨ó§U¡I
Adam

TOP

{=SUM(IFERROR(WIP!$D$2:$Y$11*(ROW(C$2:C$11)=MATCH($A2,WIP!$C$2:$C$11,)+1)*(COLUMN($E1:$Y1)>MATCH(LEFT(B$1,4),WIP!$1:$1,)+1),))

TOP

¦^´_ 7# hcm19522



·PÁ hcm19522 ¤]´£¥X¸Ñªk¡A¤£¹L¹ï©ó³Ì«á¤@¬q§äÄæ¦ìªº¦a¤è¦³ÂIºÃ°Ý....
COLUMN($E1:$Y1)>MATCH(LEFT(B$1,4),WIP!$1:$1,)+1¡÷Äæ«h¥Î¯¸ÂIE1~Y1¤¤¤ñ1006¯¸¤jªº
¤£¤Ó©ú¥ÕCOLUMNªº±ø¥ó¦¡>¤F¡A¬°¦ó§ä¨ì1006¯¸ªºÄæ¦ì«áÁÙ­n¦A+1¡A¦Ó¥B¸Õ¹L§â+1®³±¼¤]¹ï
¤£ª¾¹D¬O¤£¬O§Ú²z¸Ñ¿ù»~¤F?
Adam

TOP

¦^´_ 8# adam2010


    c3¤£¤@¼Ë ­Y¤@¼Ë¬O®ÇÃä®æ­è¦n¬O 0

TOP

=SUM(IFERROR(WIP!$E$2:$Y$11*(ROW(C$2:C$11)=MATCH($A2,WIP!$C$2:$C$11,)+1)*(COLUMN($E1:$Y1)>MATCH(LEFT(B$1,4),WIP!$1:$1,)),))
D§ïE "+1" §R±¼

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD