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

adam2010

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

¤U¸ü (69.3 KB)
Table

2016-10-14 23:15

¬d¸ß¥[Á`¬YºØ²£«~¤w¸g¹L¬Y¤@¯¸ªº¥[Á`

¤U¸ü (8.32 KB)
Count

2016-10-14 23:15

¨Ò¦pAAAA0009«~¶µ¦b#1010¯¸«áªº¥[Á`=1434(¶À©³)
¤½¦¡­n¦p¦ó³]©w¡AÁÂÁ¡I
°ÝÃD20161014.rar (7.94 KB)

File
¤U¸ü¦¸¼Æ: 13

2016-10-14 23:15

zz5151353

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

¬d¸ß¥[Á`¬YºØ²£«~¤w¸g¹L¬Y¤@¯¸ªº¥[Á`

¨Ò¦pAAAA0009«~¶µ¦b#1010¯¸«áªº ...
adam2010 µoªí©ó 2016-10-14 23:19

B2

=SUMPRODUCT(($A2=WIP!$C$2:$C$11)*(--WIP!$E$1:$Y$1>--LEFT(B$1,FIND("«á",B$1)-1)),WIP!$E$2:$Y$11)

hcm19522

=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±¼

hcm19522

¦^´_ 8# adam2010


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

adam2010

¦^´_ 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?

hcm19522

{=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),))

adam2010

¦^´_ 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

hcm19522

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

fengetianxia

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

adam2010

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